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

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

CR:384749

CR Number:   384749 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Jul 2005 Fixed Description Changed IPv6 supportive code using Sun Solaris deprecated run-time functions into the IETF designed primitives which are generic for all platforms. Workaround Description  added a resolv.conf file or added the host name and IP address to the file /etc/inet/ipnodes also eliminates the problem.

CR:384752

CR Number:   384752 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.3 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 21 Feb 2006 Fixed Description A 694 error, "An attempt was made to read logical page ... The page was not read successfully. You may have a device problem or an operating system problem", may be erroneously reported in cases where prefetch of pages is done on a server that has many concurrent I/Os that are active. Workaround Description  N/A

CR:384761

CR Number:   384761 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   all Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 01 Apr 2005 Fixed Description ASE Plug-in 15.0 Beta2 version displays incorrect values for size of Database Devices.

CR:384779

CR Number:   384779 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 May 2005 Fixed 22 Jun 2005 One-off Provided 21 Jun 2005 One-off Provided Description In rare circumstances a 701 error, "There is not enough procedure cache to run this procedure, trigger, or SQL batch. Retry later, ..." may be reported for queries that need to allocate memory chunks larger than 2 Kb (for example queries with long strings), while there is still memory available in each engine's local memory cache.

CR:384921

CR Number:   384921 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX 5.1 Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 01 Jun 2005 One-off Provided Description Instrumentation: Alarms stop working in ASE resulting in hung transaction and database dumps.

CR:385017

CR Number:   385017 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UX Original Version:   12.5.3.a Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 May 2005 Fixed Description In rare circumstances, ASE running on HP-UX, the message current process infected with 11 may be reported when dbcc printolog() is executed.

CR:385032

CR Number:   385032 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   12.5.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 24 May 2005 Duplicate Description A database that encounters an 1105 error during the ASE boot sequence is not brought online as it should.

CR:385033

CR Number:   385033 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.3 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 30 Mar 2005 Fixed 12.5.3 ESD#4 30 Mar 2005 Fixed Description Supply a document (ASE-12_5/ThirdPartyLegal/ASE-1253ThirdPartyLegal.pdf) containing licenses for third party products included as a part of ASE 12.5.3. The PDF contains links to the source code distributions for those third party components that require it as a part of their licenses.

CR:385126

CR Number:   385126 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 06 Feb 2006 Fixed Description Under circumstances, when ASE is running java( configuration parameter: enable java = 1) with multiple engines online( number of engines > 1), server could hit SIGSEGV with a stacktrace including VMLiteral. Workaround Description  NONE.

CR:385166

CR Number:   385166 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   11.5.1.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 01 Aug 2005 Fixed Description The error 3702 "Cannot drop the table '#<temp_table>' because it is currently in use." may be raised followed by error 216 "Attempt to automatically drop temporary table failed." when sp_spaceused or OAM builtins are used concurrently with sessions dropping their temporary objects. Workaround Description  Avoid running sp_spaceused in a DB with a volatile object drop.

CR:385188

CR Number:   385188 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 Apr 2009 Presently Not Targeted For Any Future Release Of This Product Description Enhance error message 10707 to include dbid, spid, uid info.

CR:385204

CR Number:   385204 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   Microsoft Windows Original Version:   Galaxy Fixed Version Build Resolution Date Closure Code (If Appropriate) 25 May 2005 Fixed 10 Jan 2006 Bundled Request Description SQL execution from server group. SQL applies to all selected servers in server group, user can view their output, status, error messages (if any) in one dialog.

CR:385338

CR Number:   385338 Product Name:   Adaptive Server Platform_Specific Docs Product Component:   Installation Guide for Solaris Status:   Open OS:   all Original Version:   12.5.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description The Install Guides make no mention of how Space is needed in the Temp Dir

CR:385401

CR Number:   385401 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 01 Apr 2005 Fixed 13 Apr 2005 Fixed 03 Jul 2005 Bundled Request Description 100030 error is reported by dbcc checkstorage for text page after cross-platform database load.

CR:385470

CR Number:   385470 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Apr 2005 Fixed Description Inf and NaN can be 'updated' into a float column using JDBC client applications. Workaround Description  None

CR:385559

CR Number:   385559 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 10 Jun 2005 Fixed 25 Oct 2005 Presently Not Targeted For Any Future Release Of This Product Description A 703 error: "There is not enough procedure cache to run this procedure, trigger, or SQL batch" may sometimes be raised if too many sort buffers have been configured with respect to the available procedure cache. This CR adds a recommendation to retry with lesser sort buffers. Workaround Description  Retry after configuring lesser number of sort buffers.

CR:385607

CR Number:   385607 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   Galaxy Fixed Version Build Resolution Date Closure Code (If Appropriate) 06 Jun 2005 Fixed 27 Sep 2005 Fixed 10 Jul 2005 Presently Not Targeted For Any Future Release Of This Product Description Feature Request-Sybase able to use the OS "DIRECT I/O" feature.

CR:385670

CR Number:   385670 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   SunOS Original Version:   12.5.3 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 Jul 2008 Insufficient priority to fix Description The primary difference between server config file and sp_configure output is - config file has info regarding individual caches however sp_configure does not. The request is to include cache info (default/named cache with poolsize) and cache binding info in sp_configure output. sp_configure just gives total and I think it makes sense to include details in sp_configure output. sp_configure output will be complete if we add sp_cacheconfig (all caches and their pool size) and sp_helpcache (cache binding). TSE's ask for server level configuration from client, they always need to see data cache configuration as well. So they end up asking outputs of three commands sp_configure, sp_cacheconfig and sp_helpcache. Workaround Description  *** Monday, April 04, 2005 8:48:57 AM *** cooperg *** Create a SP that calls the appropriate SP's to get desired output. Customer does not like this solution

CR:385700

CR Number:   385700 Product Name:   Adaptive Server Enterprise Product Component:   Historical Server Status:   Closed OS:   SunOS Original Version:   12.5.3 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 Jul 2007 Insufficient priority to fix Description Customer would like a documented/supported way to clean up the hs.ctl file and remove "invalid" entries from this file without having to reboot Historical Server, as in the case of inactive views, they can remove it using hs_delete_data, but in the case of "invalid" views they cannot. They want to clean up the hs.ctl file and keep it as small as possible with little information from the past. Workaround Description  *** Monday, April 04, 2005 10:21:54 AM *** cooperg *** N/A

CR:385720

CR Number:   385720 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   NA Original Version:   12.5.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 01 Apr 2008 Fixed Description Error 3935 may be hit and a stack trace may be encountered when a stored procedure is marked for replication and executed, and it contains more SQL "COMMIT" statements than the number of active user transactions.

CR:385755

CR Number:   385755 Product Name:   Adaptive Server Enterprise Product Component:   FTS SDS Status:   Closed OS:   AIX 5.1 Original Version:   12.5.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.5.3 ESD#3 17 May 2005 Fixed Description EFTS: When querying text index using score column produces 'VdkDocReadBatch' function failed with vdk error '-27 ' even when batch_blocksize is set to 64k. Workaround Description  set the batch_blocksize = 21845 sp_text_configure textsvr ,'batch_blocksize','21845' Depending on the columns(id, score, summary) involved in the text_index query then the customer can set the... 1) batch_blocksize=65535...if they are only going to return the id from the text_index...65535\1_column(id) 2) batch_blocksize=37768...if they are only going to return the id plus score from the text_index...65535\2_columns(id+score)...this includes just requesting score by itself since id is always implicitely returned 3) batch_blocksize=21845...if they are going to return the most...id, score, and summary columns from the text_index...65535\3_columns(id+score+summary)...this also includes any query with summary...summary by itself or coupled with id and/or score...id is always implicitly returned but for some reason when summary is requested the text server always needs to use 3 columns in the calculation.

CR:385793

CR Number:   385793 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 10 Nov 2005 Fixed 20 Apr 2009 Insufficient priority to fix Description When an attemp to run a SELECT INTO query in parallel mode fails because there is an insufficient number of worker processes, an error 11015 is raised instead of executing the query in serial mode.

CR:385795

CR Number:   385795 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.3 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Apr 2005 Fixed Description SELECT @@rowcount may return incorrect value after executing EXECUTE IMMEDIATE statement if the server configuration option "send doneinproc tokens" is set to 0.

CR:385809

CR Number:   385809 Product Name:   Adaptive Server Enterprise Product Component:   JVM Status:   Closed OS:   Linux Original Version:   12.5.2 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Sep 2006 Duplicate Description We can't set a literal message in Japanese within SQLException due to a conversion problem between UTF8 and ASE Charset. Workaround Description  none

CR:385820

CR Number:   385820 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   To Be Determined Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Currently simulated statistics can only be enabled at the session level (set statistics simulate on) which makes it very difficult to do 'what if' type analyses for a whole application (eg. double row counts for all tables) as it requires modifications to all SQL code. If we could enable simulated statistics at the database or server level then we could easily perform simulations without needing to make any changes to application code. This would help us anticipate changes in optimiser decisions (chiefly due to data growth) and eliminate unexpected degradations in performance that we experience from time to time.

CR:385824

CR Number:   385824 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) 01 Feb 2006 Duplicate Description The ADA feature allows read access to offline databases stored on archives.

CR:385826

CR Number:   385826 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) 26 May 2006 Fixed Description New feature that allows DBCC CHECKSTORAGE to be run on archive databases.

CR:385829

CR Number:   385829 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) 21 Sep 2005 Fixed Description This command should be available for all tables to be used as a "catch all" table maintenance command. It should defragment APL tables in much the same way as dropping and re-creating a clustered index does.

CR:385830

CR Number:   385830 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   To Be Determined Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Data skew: When estimating the rows returned for a point query on a non-unique index and the value falls within a range cell (rather than a frequency cell) the optimiser uses the range cell density to estimate the number of rows returned (see Chapter 17 ASE 12.5 P&T Guide - 'How optimiser uses densities and histograms'). Because the range cell density 'represents the average number of duplicates of all values that are represented by range cells in the histogram' the optimiser may make unecessarily pessimistic estimates where there are variations (ie.skew) between range cells that aren't sufficient to generate frequency cells. It occurred to me that if a density figure was generated for each range cell and stored with the histogram stats then the optimiser would get the best possible view of the distribution of duplicate values and be much less easily fooled by data skew when optimising point queries (not such an issues for range queries) - would this be possible ?

CR:385854

CR Number:   385854 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   12.5.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Feature request for a command to clear the max_used counters used in sp_monitorconfig without requiring a reboot of ASE.

CR:385942

CR Number:   385942 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Oct 2005 Fixed Description A new feature request to avoid error 7205 state 3 while a SITE HANDLER is destroying a SITEBUF.

CR:386107

CR Number:   386107 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 25 Apr 2005 Fixed Description The message 'current process (...) infected with 11' together with module eval_cnst_expr, run or com__mk_rslcnst may be generated when an incompatible constant SARG is used in a where clause. Workaround Description  The SQL itself is a semantically incorrect, so do not try to construct it.

CR:386172

CR Number:   386172 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.3 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 31 Jul 2005 Fixed Description HA VCS: Auxiliary server online operation is incorrectly reported and offline operation fails

CR:386242

CR Number:   386242 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.2 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 03 Sep 2007 Fixed Description Empty stack trace for fatal signals error like, sigsegv, sigabort, sigbus etc in native thread context.

CR:386327

CR Number:   386327 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 May 2005 One-off Provided 26 Apr 2005 Fixed 01 Jul 2005 Fixed Description Adaptive Server may provide incorrect results for ct_dynamic() call requesting CS_DESCRIBE_OUTPUT if the dynamic SQL executes multi-statement batch and SELECT statement returning the data is not the first one in the batch. Workaround Description  Don't rely on the output from ct_dynamic(CS_DESCRIBE_OUTPUT), send the execute and then use the description which comes back with the actual resultset.

CR:386421

CR Number:   386421 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Windows XP Original Version:   12.5.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Apr 2005 Fixed 14 Apr 2005 Bundled Request 03 Jul 2005 Bundled Request Description Under rare circumstances, a time slice error may happen while running a cross platform <LOAD DATABASE> command for byte-swapped architectures and if the source database contains partitioned tables.

CR:386423

CR Number:   386423 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 Apr 2005 Fixed Description Error 7351 is raised when a view is created in the same batch as a select of a variable value, although the variable is not part of the view definition.

CR:386435

CR Number:   386435 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 Feb 2009 Insufficient priority to fix Description Feature request for an "output_table" option to sp_sysmon similar to what exists for sp_monitorconfig Review Status  F

CR:386445

CR Number:   386445 Product Name:   Adaptive Server Enterprise Product Component:   omni Status:   Closed OS:   all Original Version:   12.5.3 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Apr 2005 Fixed 08 Jul 2005 Fixed Description A column defined in DB2 as LONG VARCHAR was not being mapped correctly and any SELECT of the column would fail to return the correct data.

CR:386447

CR Number:   386447 Product Name:   Adaptive Server Enterprise Product Component:   srvbuild Status:   Closed OS:   all Original Version:   12.5.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 22 Nov 2005 Fixed 09 Nov 2005 Fixed Description srvbuild fails to build ASE if the master device size configuration is set to more than 2GB Workaround Description  Build server with master device < 2GB, then DISK RESIZE it to larger size

CR:386769

CR Number:   386769 Product Name:   Adaptive Server Enterprise Product Component:   MDA/Monitoring Tables Status:   Closed OS:   all Original Version:   12.5.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 23 Dec 2005 Bundled Request 23 Dec 2005 Bundled Request Description A new column ErrorStatus has been added to monSysStatement, indicating the error status upon completion of statement execution.

CR:386869

CR Number:   386869 Product Name:   Sybase SQL Server Product Component:   dataserver Status:   Open OS:   NA Original Version:   12.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Feature request for a stored procedure to calculate the tempdb space needed to run update index statistics on a table

CR:386897

CR Number:   386897 Product Name:   Adaptive Server Generic Docs Product Component:   Reference Manual:Procedures Status:   Closed OS:   all Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 24 Apr 2012 Added to user documentation Description clarify when it is unnecessary to use sp_addobjectdef

CR:386912

CR Number:   386912 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 26 Apr 2005 Fixed 14 Jul 2005 Fixed Description The message "current process infected with 11" in the module 'com__subquery' together with a stack trace which includes the modules 'constree' and 'com__op' may be reported in the error log for a SELECT with a subquery under a CASE statement and an OR clause. A view using the same combination can also result in error 3626, "The transaction was aborted because it used too much stack space"

CR:386928

CR Number:   386928 Product Name:   Adaptive Server Enterprise Product Component:   DBISQL Status:   Closed OS:   all Original Version:   Galaxy Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 Dec 2006 Bundled Request Description Previously for ASE, Interactive SQL only limited the displayed rows on the client side without limiting the number of rows sent by the server through "set rowcount" command. This has been fixed.

CR:386931

CR Number:   386931 Product Name:   Adaptive Server Enterprise Product Component:   DBISQL Status:   Closed OS:   all Original Version:   Galaxy Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.0 ESD#1 14 Oct 2005 Fixed Description Previously DBISQL does not display query result similar to the that of command-line isql. This has been addressed by adding a "Text" output mode, in addition to existing "Grid" output mode. To turn on Text output, open Options dialog by selecting menu item "Tools"->"Options...". On Options dialog, select "Results" from the left-hand-side list and select "Text" radio button to enable text output.

CR:386987

CR Number:   386987 Product Name:   Adaptive Server Generic Docs Product Component:   Using Sybase Failover In a HA System Status:   Open OS:   all Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Need to document valid values and meaning of each filed of ase_monitor_action

CR:387023

CR Number:   387023 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.3 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 May 2005 Fixed 10 Jul 2009 Insufficient priority to fix Description Queries containing many aggregates and at least one AVG() may return incorrect results or fail with a stack trace on 64bit platform.

CR:387036

CR Number:   387036 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15 Apr 2005 Fixed 18 Apr 2005 Fixed 08 Jul 2005 Fixed Description sp_start_rep_agent with 'recovery' option run for an offline database will report the error 9280: Unable to start repagent on database <dbname> because that database has not been recovered and/or is not online.

CR:387059

CR Number:   387059 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   all Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Jun 2005 Fixed Description Temporary Databases and User Created temporary databases are not listed in Cache Bindings list.

CR:387121

CR Number:   387121 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.3 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Jun 2005 Fixed 10 Aug 2005 Fixed 11 Aug 2005 Fixed Description HA: On ASE HA Active/Passive configuration with Sun Cluster 3.x environment, if a child ASE monitor process (ase_monitor) dies, a parent ASE monitor process restarts ASE.

CR:387143

CR Number:   387143 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.3 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 Apr 2005 Fixed Description An exec immediate SQL command using a command string built from concatenated strings can fail with syntax errors or generate incorrect results if one of the strings used to built the command string has a NULL/empty value. Workaround Description  Use " quotes like exec (".....") instead of exec ('....') more important, don't use an empty variable to built the command !!

CR:387239

CR Number:   387239 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   12.5.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Feature request for a dbcc command to correct a corrupt allocation page

CR:387279

CR Number:   387279 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   12.5.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 26 Apr 2005 Fixed 09 May 2005 Fixed Description An 875 error, "Unable to grab a buffer to allocate a page to the log in database id <id>..." may be reported on a heavily-used 32bit Linux system that is making use of large memory support (the "extended cache size" configuration parameter is non-zero). Now, the wash size for the <server page size> pool in all user-configured caches (not the extended cache), is set to the configured wash size; prior to this change it was set to a fixed value. Workaround Description  Set the configuration parameter, 'i/o batch size' to 10 (the default is 100).

CR:387287

CR Number:   387287 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   To Be Determined Fixed Version Build Resolution Date Closure Code (If Appropriate) 08 Jun 2005 Fixed 07 Dec 2005 Presently Not Targeted For Any Future Release Of This Product Description When sampling for update statistics is enabled and the index/column does not have existing statistics, then the resulting join density and total density are set to a default value of 0.1. Traceflag 2703 is now provided such that when the traceflag is turned on, the join and total density will be gathered from the sample instead of being set to the default value.

CR:387313

CR Number:   387313 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 05 Jun 2005 Fixed Description LOAD DATABASE has a new option, WITH VERIFY[ONLY] [= HEADER | FULL ]. This performs basic page header sanity checks (HEADER) and both page header checks and intra-page row checks (FULL) on every page loaded. If VERIFYONLY is used, the pages are read and checked from the dump archive but they are not copied onto the database devices.

CR:387421

CR Number:   387421 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 27 May 2005 Fixed Description A stored procedure that has a statement whose execution requires a work table creation, may encounter remapping problems when the statement is executed using the pass through mode on a remote server and the local server has multiple temporary databases defined. The problem will manifest with the message "current process ... infected with 11" in module proc__reset_wktbl().

CR:387440

CR Number:   387440 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 27 Apr 2005 Fixed 04 Aug 2005 Fixed Description The error 8419 "Could not find index descriptor for objid <value>, indid <value> in dbid <value>." may be raised during the recovery phase of a database with a stack trace reported in the error log with modules 'recovery', 'pg_zap_dealbit_db' and 'pg__recalc_oams'.

CR:387454

CR Number:   387454 Product Name:   Adaptive Server Generic Docs Product Component:   Using Sybase Failover In a HA System Status:   Closed OS:   all Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 May 2005 Fixed Description $SYBASE/$SYBASE_ASE/SC-3_0/log directory does not exist. After installing ASE, you need to create it to store callback_log and monitor_log files.

CR:387469

CR Number:   387469 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.3 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 22 Jun 2005 Fixed Description HA SC 3.x: If a parent ase_monitor is dead after a child ase_monitor is dead, ase_monitor processes do not wake up and nobody monitors dataserver process. Workaround Description  Change line 1615 in $SYBASE/$SYBASE_ASE/SC-3_0/bin/utils.ksh as follows: Before: 1615 pmfadm -E -c $PMF_TAG -n -1 -t -1 \ 1616 `dirname $0`/ase_monitor $RESOURCEGROUP_NAME $RESOURCE_NAME After: 1615 pmfadm -E -c $PMF_TAG -n -1 -t -1 -C 0 \ 1616 `dirname $0`/ase_monitor $RESOURCEGROUP_NAME $RESOURCE_NAME

CR:387506

CR Number:   387506 Product Name:   ASE Replicator Product Component:   Doc Status:   Closed OS:   Generic Original Version:   NA Fixed Version Build Resolution Date Closure Code (If Appropriate) 26 Apr 2005 Not a Bug Description Document use of sp_skiptran subname[, num_to_skip ] as being a replacement of sp_resumesub ... withskip option Workaround Description  Be sure that Replicator is quiesced first. Then you can either fix the offending data by correcting the appropriate shadow table(s), or you can delete all the rows of the offending transaction from the tran-log table.

CR:387523

CR Number:   387523 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   12.5.3 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 08 Jun 2005 Fixed 03 Jun 2005 Fixed 23 Jun 2005 Fixed 21 Aug 2005 Fixed Description On a 32 bit Linux platform, a 695 or 697 error may be reported in a server configured with 2K pages and Large Memory Support(the "extended cache size" is set to a non-zero value).

CR:387532

CR Number:   387532 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Apr 2005 Fixed Description The message "infected with 11 in mda_populate_monCachedProcedures()" together with a stacktrace containing the modules 'mdarpc_exec' and 'exec__native_rpc' may be written to the errorlog when ASE monitoring tables are enable and the 'number of open objects' parameter is not configured high enough.

CR:387680

CR Number:   387680 Product Name:   Adaptive Server Enterprise Product Component:   omni Status:   Closed OS:   all Original Version:   12.5.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 26 Apr 2005 Fixed 20 May 2005 Fixed 05 Jun 2005 Fixed 24 May 2005 One-off Provided 12 Jun 2005 Fixed 04 Jul 2005 Fixed 14 Jul 2005 Fixed Description CIS: SELECT from proxy_table might return the number of rows according to the previous SET ROWCOUNT, even though the rowcount has been set back to 0. Workaround Description  set rowcount <a really big number>

CR:387711

CR Number:   387711 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 26 May 2005 Fixed Description Recompilation of a stored procedure containing a statement with correlated subquery in the HAVING clause may lead to different errors indicating query tree corruption.

CR:387722

CR Number:   387722 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   12.5.3 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 28 Apr 2005 Fixed Description The ASE for the 64-bit linux platform for the AMD64 process in the ASE 12.5.2 release can be run without any license. The licensing is not enforced in that ASE software. With this new release for the 64-bit Linux platform for the AMD64 processor in the ASE 12.5.3 release, the licensing requirement is enforced in the ASE software. For the step to add licensing, refer to chapter 3, Sybase Software Asset Management (SySAM) in the Install Guide for Linux.

CR:387753

CR Number:   387753 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.3.a Fixed Version Build Resolution Date Closure Code (If Appropriate) 21 Apr 2005 Fixed Description If the debug version of ASE is booted with the trace flag 722, the server performs additional checks on the heap memory to detect possible memory corruption.

CR:387756

CR Number:   387756 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 26 Apr 2005 Fixed Description The message infected with 11 in decision is printed in the errorlog, together with a stacktrace containing the modules 's_compile_stmt', 'execproc' and 's_execute', when executing a stored procedure which performs a select from a view having a UNION clause. This statement must be the second statement in the stored procedure. Workaround Description  Recreate the query tree of the problem sproc via: dbcc upgrade_object(dbname, sproc_name) from the text stored in syscomments.

CR:387857

CR Number:   387857 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.3.a Fixed Version Build Resolution Date Closure Code (If Appropriate) 03 May 2005 Fixed 28 Feb 2006 Presently Not Targeted For Any Future Release Of This Product 22 Jun 2005 Fixed 07 Jul 2005 Fixed 12 Jul 2005 Fixed 11 Jul 2005 Fixed Description ASE on Windows uses Certicom SSL Plus 3.1.15b libraries, and ASE on UNIX platforms uses Certicom SSLPlus 3.1.14 libraries.

CR:387878

CR Number:   387878 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   SunOS Original Version:   12.5.3 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 10 Jun 2005 Fixed 05 Jul 2006 Not a Bug Description Query with index joins may execute very slowly. Workaround Description  For 15.0, issue 'set plan optgoal allrows_dss' before the select query.

CR:387910

CR Number:   387910 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   Microsoft Windows Original Version:   12.5.3 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description add new resource files to the install doc... sybatch_ase.res sybatch_bs.res sybatch_ms.res

CR:387954

CR Number:   387954 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.3 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 04 Sep 2005 Fixed 28 Sep 2005 Fixed 11 Oct 2005 Fixed 08 Nov 2005 Fixed 24 Nov 2005 Fixed Description Sub-optimal performances may be seen on queries with <LIKE>...<ESCAPE> expressions

CR:387963

CR Number:   387963 Product Name:   Adaptive Server Enterprise Product Component:   xpserver Status:   Closed OS:   all Original Version:   12.5.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description XPserver: should send wide column results to those clients that are capable of supporting them and use 255 character limits for older clients. Workaround Description  None known.

CR:387979

CR Number:   387979 Product Name:   Adaptive Server Enterprise Product Component:   Monitor Client Status:   Closed OS:   NA Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 28 Apr 2005 Fixed Description Not customer visible

CR:388018

CR Number:   388018 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   12.5.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 27 May 2005 Fixed 08 Dec 2005 Fixed Description In rare circumstances, the ONLINE DATABASE command fails with a 2610 error after a cross-platform database load. To avoid this error, run "dbcc traceon(3199)", reload the dump and online the database using "ONLINE DATABASE".

CR:388024

CR Number:   388024 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16 May 2006 Fixed 27 Aug 2006 Fixed 28 Aug 2006 Fixed Description Feature request to make the timeslice error message less cryptic.

CR:388061

CR Number:   388061 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) 27 Apr 2005 Fixed Description add the following chart to the... 12.5 System Administration Guide ...to help with configuring 8 page I/O buffer pool for checkstorage Chapter 25 Checking Database Consistency ... Preparing to use dbcc checkstorage ... Configuring Adaptive Server for dbcc checkstorage ... Configuring an 8 page I/O buffer pool The dbcc checkstorage buffer pool requirements for the different page sizes in 12.5 are as follows: (2k page server) * (8 extents) = 16k buffer pool (4k page server) * (8 extents) = 32k buffer pool (8k page server) * (8 extents) = 64k buffer pool (16k page server) * (8 extents) = 128k buffer pool

CR:388074

CR Number:   388074 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UX Original Version:   12.5.3.a Fixed Version Build Resolution Date Closure Code (If Appropriate) 05 May 2005 Fixed Description Under stress conditions, ASE running on HP-UX, the message 'current process infected with 11' together with a stack trace which include the module 'addCharArrays' may be reported in the error log when the client is using SSL.

CR:388213

CR Number:   388213 Product Name:   Adaptive Server Generic Docs Product Component:   System Administration Guide Status:   Closed OS:   all Original Version:   12.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 27 Apr 2005 Fixed Description replace all dbcc engine references for starting stopping engines with sp_engine in System Administration Guide

CR:388267

CR Number:   388267 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.3 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 Aug 2005 Fixed Description After failover is complete, sometimes a child ase_monitor process still remains on primary node. Workaround Description  Kill a child ase_monitor process manually if it still remains on primary node after failover.

CR:388281

CR Number:   388281 Product Name:   Adaptive Server Enterprise Product Component:   backup server Status:   Closed OS:   macosx Original Version:   12.5.3 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 03 Apr 2006 Fixed 03 Apr 2006 Fixed 03 Apr 2006 Fixed Description On Mac OS X platform, 6.66.2.1 error, "Volume validation error: illegal volume change, device <device name>: volume mounted out of order, expected volume 0001, got volume 16777216.", is reported by Backup Server when running load database with a dump file that was generated on little-endian platform. Workaround Description  Nothing

CR:388401

CR Number:   388401 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Microsoft Windows Original Version:   12.5.2 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 May 2005 One-off Provided 27 May 2005 Fixed 06 Jun 2005 One-off Provided Description Sybmon dump with ASE 12.5.2 ESD#2 on Windows platform fails. ASE reports seek error in errorlog similar to 'File positioning failed (4).Seek offset: 828964864'

CR:388427

CR Number:   388427 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UX Original Version:   12.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 May 2005 Fixed Description The message "current process infected with 11 in expand_ALL_nodes" is printed in the ASE errorlog together with a stacktrace containing the modules 'd_upgradeobj', 's_normalize' and 'u_view_driver' when executing the command DBCC UPGRADE_OBJECT() on a stored procedure containing a view having a SELECT * on a table which is dropped and recreated before executing the actual DBCC command.

CR:388430

CR Number:   388430 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   NA Original Version:   12.5.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Nov 2005 Fixed Description sp_estspace output is incorrect for APL tables with short rows on wide page size. There is a limit of 256 rows per page that the code does not account for.

CR:388475

CR Number:   388475 Product Name:   Adaptive Server Enterprise Product Component:   xpserver Status:   Closed OS:   Microsoft Windows NT Original Version:   12.5.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Jun 2005 Fixed Description On the Windows platform, issuing the xp command "xp_cmdshell 'type long.txt'" where long.txt is a text file with a very long line (>255 characters) of text and no final carriage return, will result in the text file being repeatedly typed in an infinite loop

CR:388560

CR Number:   388560 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   all Original Version:   12.5.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 29 Apr 2005 Fixed Description Move binaries under shared/lib folder to ASEP/lib folder. Remove About ASE Plugin Dialog as the same information is displayed in ASE Plugin properties.

CR:388586

CR Number:   388586 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   NA Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 31 Jan 2006 Fixed 31 Jan 2006 Fixed Description Various Enhancements of performance of TEMPDB especially to avoid writing buffers to disk as part of checkpoint, minimal logging of TEMPDB activity, separate ULC for tempdb. Please see what's new for the detailed of these enhancements.

CR:388663

CR Number:   388663 Product Name:   Adaptive Server Enterprise Product Component:   backup server Status:   Open OS:   all Original Version:   12.5.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description BackupServer: new feature request to speed load from tape by specifying "norewind" option when tape is known to be at the correct position. Workaround Description  None, but put smallest dumps on tape first to speed load times.

CR:388670

CR Number:   388670 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.3 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 04 Sep 2006 Fixed Description The command LOAD WITH VERIFY[ONLY] is not supported on cross platform load, however it was allowed causing all sort of invalid verification errors.

CR:388766

CR Number:   388766 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX 5.1 Original Version:   12.5.3 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 29 Nov 2005 Fixed Description PERMISSIONS Exec (@sql_text) inside store procedure not working Workaround Description  /** workaround **/ create procedure testproc3 as declare @sql_txt varchar(255) select @sql_txt = "delete test..sysusers where test..sysusers.name = 'testuser'" execute sp_configure "allow updates", 1 execute (@sql_txt) execute sp_configure "allow updates", 0 go use test go exec sybsystemprocs.dbo.testproc3 go

CR:388889

CR Number:   388889 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 04 Sep 2005 Fixed Description CIS: Selecting from proxy MSSQL table involving builtin functions hextoint/inttohext could give an error "... not a recognized function name" from the backend server.

CR:388984

CR Number:   388984 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 05 Jun 2006 Presently Not Targeted For Any Future Release Of This Product 21 May 2006 Fixed 06 Jun 2006 Fixed 27 Jun 2006 Reservation Made 29 Apr 2006 Duplicate 06 Aug 2007 Added to user documentation Description Added new T-SQL builtin, PARTITION_OBJECT_ID() that displays the object ID given a partition ID and an optional database ID. Interface is PARTITION_OBJECT_ID(<partition ID> [, <database ID>]). Returns NULL for non-existent or invalid input arguments.

CR:389073

CR Number:   389073 Product Name:   Adaptive Server Enterprise Product Component:   sybmigrate Status:   Closed OS:   Linux Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 Jul 2005 Not reproducible with latest version of the product available as of Resolution Date Description A dbcc checktable can give error 7930 on tables with a clustered index after using migration tool to migrate to a windows server using 16k pages. (7930 error:) Table Corrupt: Keys in the left child page do not precede the parent key; check page %d, partition ID %d. Workaround Description  Two alternate workarounds: (1) If migrating tables with clustered indexes to a 16k page size windows server use the migration tool traceflag NO_SORTED_DATA: $ sybmigrate -T NO_SORTED_DATA This will ensure the clustered index is recreated correctly after the table data has been copied. (2) If migration has completed without the traceflag and dbcc checktable is reporting the error dropping and recreating the clustered index will resolve the problem.

CR:389076

CR Number:   389076 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.3 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 May 2005 Fixed 16 Sep 2005 Fixed 16 Sep 2005 Fixed Description The message "current process infected with 11" may be raised in module bufdlink() when the sysindexes system catalog and the database where it resides are bound to different named caches, and when the clustered index of sysindexes is not explicitly bound to a named cache. Workaround Description  If you bind sysindexes to a named cache, explicitly bind sysindexes.sysindexes index to either the same named cache, or to the cache the database is bound to.

CR:389129

CR Number:   389129 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 Jun 2005 Fixed Description Error 511 "Attempt to update or insert row failed because resultant row of size <value> bytes is larger than the maximum size (<value> bytes) allowed for this table..." may be raised during the execution of a stored procedure using the reformatting strategy and the creation of a DOL (Datarows Only Locking) work table. Alternatively the error 9561 "An insert or update to table 'temp worktable' places column '(unknown column)' at offset <value>..." may be raised.

CR:389154

CR Number:   389154 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   Galaxy Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 Mar 2006 Fixed 31 Aug 2006 Fixed Description If a very large transaction is rolled back then "KILL <spid> WITH STATUSONLY" may report negative values.

CR:389218

CR Number:   389218 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Oct 2005 Fixed Description Illegal escape sequences in Unicode literals (U&'...') are not detected properly when the server's default character set is configured as UTF-8.

CR:389227

CR Number:   389227 Product Name:   Adaptive Server Enterprise Product Component:   MDA/Monitoring Tables Status:   Closed OS:   all Original Version:   12.5.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 Mar 2008 Fixed Description Feature Request: Currently. monOpenDatabases.BackupStartTime is updated for database and transaction dumps. Transaction dumps should be seperated into their own field.

CR:389239

CR Number:   389239 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.3.a Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 Oct 2006 DEFER 08 Nov 2006 Fixed Description 1) sp_encryption system stored procedure uses tempdb excessively. 2) Running sp_encryption when there are no keys in the database produces no output. 3) sp_encryption enhancements to display keyname, tablename, column name and key details.

CR:389280

CR Number:   389280 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.3 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 23 Sep 2005 Not a Bug Description Under certain circumstances although a join-query executed against ORACLE tables mapped locally in ASE as proxy tables is not pushed entirely to the ORA-side although this is completely possible