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

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

CR:545968

CR Number:   545968 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.2 ESD#6 Fixed Version Build Resolution Date Closure Code (If Appropriate) 08 Oct 2008 Fixed Description Executing an outer join query with false predicate (e.g. "1 = 2") in the ON clause may hit error 1142 if reformatting strategy is chosen.

CR:546047

CR Number:   546047 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.2 ESD#5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Oct 2008 Fixed 14 Oct 2008 Fixed Description Executing a query involving IN clause, some builtin and OR predicate may hit SEGV and stack trace in the module of 'LeEvals::LeEvRun()' and 'LeOrScanContext::setOrVtuple' if the query plan chosen has OrScan in it. Workaround Description  Declare @UserName as VARCHAR of some length less than 256, e.g., declare @UserName VARCHAR(255)

CR:546057

CR Number:   546057 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   NA Original Version:   15.1 ESD #4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Oct 2008 Fixed Description After bringing an engine back online that has been previously taken offline incorrect messages may appear in the errorlog related to the clock on that engine not running.

CR:546075

CR Number:   546075 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.2 ESD#6 Fixed Version Build Resolution Date Closure Code (If Appropriate) 22 Oct 2008 Fixed 21 Oct 2008 Fixed 29 Oct 2008 Fixed 30 Oct 2008 Fixed 31 Oct 2008 Reservation Made 14 Jan 2009 One-off Provided Description The message "process infected with signal 11" in the module 'des_rekeep' may be reported in the error log together with a stack trace which includes the modules 'vu_getviewdefn', 's_reinstallProcTree' and 'proc__linktopss' when two concurrent sessions access a VIEW whose query tree needs to be redefined by ASE. Workaround Description  update 6/11/09 ningzhen: Customers may use tool "dbcc upgrade_object --with 'force'" to rebuild query trees in sysprocedures to reduce the chance of run time upgrade. e.g. in pubs2 1> dbcc upgrade_object <-- rebuild query trees for all compiled objects 2> go DBCC upgrade_object: Upgrading VIEW dbo.sysquerymetrics DBCC upgrade_object: VIEW dbo.sysquerymetrics upgraded successfully. DBCC upgrade_object: Upgrading PROCEDURE dbo.title_proc .... dbcc upgrade_object(pubs2,titleview) <-- rebuild query tree for view titleview

CR:546085

CR Number:   546085 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.2 ESD#6 Fixed Version Build Resolution Date Closure Code (If Appropriate) 09 Oct 2008 Fixed 10 Oct 2008 Fixed Description In cases where basic_optimization is used, and the histogram on a column has been explicitly deleted by the delete statistics command, there is a possibility of a stack trace if multi-attribute densities exist with that leading column. This could happen if a multi-attribute index exists, and the histogram on the leading column of that index is explicitly deleted.

CR:546125

CR Number:   546125 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.2 ESD#5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 10 Nov 2008 Fixed 10 Nov 2008 Reservation Made Description A cursor on an APL table in 12.5 prefers a unique index rule based over any non-unique index or table scan. In 15.0 the unique index is only used rule based if a FOR UPDATE clause was specified. The 12.5 unique index rules are now supported for 15.0 Workaround Description  1)create cursor as insensitive "declare cur_proc insensitive cursor for" 2) use a AP to force index. "PLAN '( i_scan indexname tablename )'"

CR:546127

CR Number:   546127 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 21 Oct 2008 Fixed 29 Jan 2009 Bundled Request Description <permission_name> is allowed to be entered as first argument to sp_helprotect where as the syntax of sp_helprotect is: sp_helprotect [name [, username [, "grant" [,"none"|"granted"|"enabled"|role_name [,permission_name]]]]]

CR:546149

CR Number:   546149 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   pyxis Fixed Version Build Resolution Date Closure Code (If Appropriate) Description In rare cicumstances, in multinode cluster error 8211 may reported while creating/accessing the table.

CR:546158

CR Number:   546158 Product Name:   Adaptive Server Enterprise Product Component:   backup server Status:   Closed OS:   Linux Original Version:   15.0.2 ESD#6 Fixed Version Build Resolution Date Closure Code (If Appropriate) 21 Nov 2008 Duplicate Description BackupServer crashes on glibc 2.6 (Suse 10.3 and 11) Workaround Description  Setting LD_POINTER_GUARD to 0 can be a workaround for this issue. But, this workaround is not effective everywhere, on some platforms with glibc 2.6 setjmp/longjmp still fail.

CR:546169

CR Number:   546169 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description FR: Tool for estimating the amount of time it will take to create an index.

CR:546179

CR Number:   546179 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.2 ESD#6 Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 Nov 2008 Fixed Description Wrong result might happen for outerjoin query with a MATCHNULL equijoin WHERE clause. Workaround Description  cmdline traceflag 15387 could be used to disable MATCHNULL tcid enhancement to avoid the bug.

CR:546204

CR Number:   546204 Product Name:   Adaptive Server Generic Docs Product Component:   EFTS SDS and SFTS SDS Status:   Closed OS:   all Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 09 Feb 2009 Added to user documentation Description max_stacksize parameter increased in EFTS 15.0.2 from 34816to value 131072. Stacksize has been increased due new Verity libs

CR:546205

CR Number:   546205 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   Solaris Original Version:   15.0.2 ESD#5 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Implementation of an option in Update Index Statistics command which will allow to decide to do one Index Scan for each non leading column (like is today) or do only one Index scan for reading all non-leading columns.

CR:546255

CR Number:   546255 Product Name:   Adaptive Server Generic Docs Product Component:   System Administration Guide Status:   Closed OS:   all Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 Feb 2009 Added to user documentation Description DOC : There is a limitation that ASE does not parameterize literals in a derived table.

CR:546291

CR Number:   546291 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.0.2 ESD#5 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description FR: enable housekeeper GC to be configurable per database.

CR:546301

CR Number:   546301 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.0.2 ESD#5 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Feature Request: Each entry in sysaudits that has multiple rows (sequence#) should have the identical timestamp for each sequence entry of that command.

CR:546319

CR Number:   546319 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.2 ESD#5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 05 Feb 2009 Not a Bug Description adhoc vs. sproc. adhoc picks best plan in sub seconds, while the same sproc picks wrong index, and 138 seconds. Workaround Description  create index Testidx on PAT_PLAN(PLAN_CODE, PAYOR_CODE, PAT_ID)

CR:546352

CR Number:   546352 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.1 ESD #4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Oct 2008 Fixed Description There was an attempt to de-reference a NULL pointer, while checking for the physical lock when latching a buffer that is destroyed.

CR:546359

CR Number:   546359 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.2 ESD#6 Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Oct 2008 Fixed Description INTERNAL ONLY : queries with LIKE clauses using variables under OR predicate may provide incorrect results.

CR:546364

CR Number:   546364 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.1 ESD #4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 31 Oct 2008 Fixed Description Under rare circumstances and after failover recovery has taken place, ASE may raise a fatal 890 error reading "The mass containing the buffer 'BUF=<Buffer Address>, MASS=<MASS Address>, Buf#=<Buf count>, page=<Page Address>, dbid=<DBID>, Mass vdevno=<VDEVNO>, vpage=<Virtual Page #>, Buf lpage=<Logical Page #>,Mass stat=<Mass Status>, Buf stat=<Buffer status>, size=<Page size>, cid=<Cache id> ('<Cache Name>'), Pinned xdes=<XDES Adress>, spid=<Spid #>' should not be written in its current state."

CR:546400

CR Number:   546400 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   RH Linux Original Version:   15.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 29 Dec 2008 Bundled Request Description select @@dbts returns incorrect value on ibmplinux.

CR:546419

CR Number:   546419 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Windows Original Version:   15.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 24 Nov 2008 Fixed Description On ASE running on the Windows platform, attempted java network connection may fail with "java.io.IOException: Unable to establish loopback connection"

CR:546422

CR Number:   546422 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   16.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 09 Dec 2008 Fixed Description Add an option [overwrite|append] in readtext command to specify whether to overwrite or append existed files.

CR:546434

CR Number:   546434 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.4 ESD#8 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16 Oct 2008 Fixed 18 Dec 2008 Presently Not Targeted For Any Future Release Of This Product 27 Oct 2008 Fixed Description Re-write of the query tree under traceflag 299 causes exclusive locks on sysprocedures. This happens when there is an UPDATE STATISTICS command in the procedure on the newly created temporary table.

CR:546500

CR Number:   546500 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   Solaris Original Version:   15.0.2 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description In rare circumstances sp_who does not show the correct user working DB when the user has default DB.

CR:546525

CR Number:   546525 Product Name:   Adaptive Server Platform_Specific Docs Product Component:   Release Bulletin for Solaris Status:   Closed OS:   Solaris Original Version:   12.5.4 ESD#10 Fixed Version Build Resolution Date Closure Code (If Appropriate) 21 Mar 2013 Fixed Description In the Release Bulletin Adaptive Server Enterprise 12.5.4 for Sun Solaris, it lists all the Sun Solaris Patches required on Solaris 8. However,The Patch 110648-13 and 109210-12 are required only when the customer is using Sun Cluster and ASE HA option. This is not clearly stated in our release bulletion. we need to revise this and give more precise statement regarding this, which recommend customer to examine the patches carefully and decide whether to apply such patches or not.

CR:546556

CR Number:   546556 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Request to disable foreign key constraints without dropping them. Workaround Description  N/A

CR:546574

CR Number:   546574 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) 11 Dec 2008 Fixed Description Help infomation for dbcc housekeeper is changed from: housekeeper 'pr_gcq' | 'pr_tsq' | 'pr_tsq', [<engid>]\n [...] to housekeeper ( 'pr_gcq' | 'pr_tsq' | 'pr_asq', [<engid>] ) \n [...] so that correct the duplicate flag for pr_tsq, and will allow users to print account stats queue correctly.

CR:546598

CR Number:   546598 Product Name:   Adaptive Server Generic Docs Product Component:   System Administration Guide Status:   Closed OS:   all Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 05 Jan 2009 Added to user documentation Description Customer requested that we clarify that tempdb is not newly created each time ASE is rebooted in the following section of the System Administration Guide. http://infocenter.sybase.com/help/topic/com.sybase.help.ase_15.0.sag1/html/sag1/sag1392.htm change: To make an option or options take effect for every new database, change the option in the model database. to: To make an option or options take effect for every new user defined database, change the option in the model database. Note: changes to the dboptions of model do not affect tempdb or user defined multiple tempdbs upon restart of ASE. Only newly created user defined databases and multiple tempdbs will reflect the dboptions of model, with the "create database" command. A restart of ASE clears the objects and data contained in the temporary databases, but does not reset the dboptions.

CR:546651

CR Number:   546651 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.2 ESD#6 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16 Oct 2008 Fixed 22 Oct 2008 Fixed 30 Mar 2009 One-off Provided Description SET PROXY executed in the procedure using deferred compilation will not have its scope limited only to the current procedure execution but for the whole session. Workaround Description  Start server with "-T 7730" to disable deferred compilation.

CR:546667

CR Number:   546667 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.1 ESD #4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16 Oct 2008 Fixed Description In a multi-node cluster, if config parameter "license information" is set to non-zero value, shutdown of cluster/instance may result in SIG 11 reported in errorlog. Stacktraces could contain the words "log_license_info", "open__byname".

CR:546695

CR Number:   546695 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   Solaris Original Version:   15.0.2 ESD#5 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description ASE 15.0 uses more IO to run the same query vs ASE 12.5

CR:546707

CR Number:   546707 Product Name:   Adaptive Server Enterprise Product Component:   optdiag Status:   Closed OS:   Linux Original Version:   15.0.2 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 25 Mar 2009 Fixed Description Cannot run optdiag when ASE parameter "net password encryption reqd" is enabled

CR:546712

CR Number:   546712 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 29 Oct 2008 Bundled Request Description If sp_setreplicate is run to turn off replication on a table previously configured to use SQL statement replication, this information is not removed from the system table sysattributues.

CR:546730

CR Number:   546730 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 Oct 2008 Fixed Description Error 124 raised when 'set statement_cache on' or 'set literal_autoparam on' is the only statement in a stored procedure.

CR:546737

CR Number:   546737 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 09 Dec 2008 Fixed 08 Dec 2008 Reservation Made 10 Dec 2008 Fixed Description If sort nodes break up a chain of nested loop join operators, in which some of the respective index/table scans involve an MRU strategy, and there does not appear to be a reason for the sort node, then it may be caused a buffer manager optimization that did not take into account the MRU strategy when estimating buffer cache used by the respective operators. This change will tend to reduce the usage of sort nodes to break up a chain of nested loop operators Workaround Description  abstract plans

CR:546770

CR Number:   546770 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plugin Status:   Closed OS:   HP-UX Original Version:   15.1 ESD #4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Oct 2008 Fixed Description UAF may take a long time to discover and validate hosts.

CR:546839

CR Number:   546839 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.0.2 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Nov 2008 Not a Bug Description On specific platforms, certain versions of ASE do not appear to register I/O busy in reports from sp_sysmon as expected. Workaround Description  A work around would be to use mda tables to monitor performance, including monDeviceIO, monEngine, monIOQueue

CR:546868

CR Number:   546868 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   12.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Feature request for the ability to audit the values of parameters passed to prepared statements.

CR:546883

CR Number:   546883 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 26 Jan 2009 Fixed 18 Feb 2009 Fixed Description On HP platform, disabling network IO for Java still allows some network related Java calls to be executed. This is only seen with the dataserver binary, not the diagserver binary. Workaround Description  If network related operations are not permitted, one should not allow java classes to be loaded in the database which use network related functionality.

CR:546891

CR Number:   546891 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.7 SP110 28 Jun 2013 Fixed 15.7 SP60 30 Jul 2013 Fixed Description Permissions on "sysslices" system table remain unchanged when "GRANT DEFAULT PERMISSIONS ON SYSTEM TABLES" or "REVOKE DEFAULT PERMISSIONS ON SYSTEM TABLES" SQL commands are executed.

CR:546900

CR Number:   546900 Product Name:   Adaptive Server Generic Docs Product Component:   P&T: Basics Status:   Closed OS:   all Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 04 Dec 2009 Added to user documentation Description The discussion of transaction isolation level 0 (dirty reads) should document that dirty reads can only be done in purely read-only statements. Dirty reads cannot be done for the select part of an INSERT SELECT or a SELECT INTO statement.

CR:546902

CR Number:   546902 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.1 ESD #4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 22 Oct 2008 Fixed Description After an HAFailover enabled client session has been migrated, then killed, a failover connect attempt fails with "HA Login failed. Session Handle not found.

CR:546941

CR Number:   546941 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.1 ESD #4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Jan 2009 Fixed Description In the cluster environment, the server may hang if the "abort_js" command is issued.

CR:546946

CR Number:   546946 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plugin Status:   Closed OS:   Solaris Original Version:   15.0.2 ESD#5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 23 Dec 2008 Fixed Description request the plugin of Sybase Central for ASE CE to take in the "time" value like the command "sp_cluster 'logical', 'offline', <lcname>, 'cluster'[, <wait_option>[,<time>[, @handle output]]]"

CR:546948

CR Number:   546948 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 23 Oct 2008 Presently Not Targeted For Any Future Release Of This Product Description feature request: Allow sysattributes to be bound to a named cache.

CR:546960

CR Number:   546960 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) 25 Apr 2009 Fixed Description During failover recovery, thmgr scan might count incorrect value for allocated log pages in the database.

CR:546961

CR Number:   546961 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   pyxis Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Nov 2008 Fixed 18 Jan 2009 Fixed 12 Nov 2008 Fixed 12 Nov 2008 Fixed 12 Nov 2008 Fixed 16 Feb 2009 Fixed Description Enable RTDS to support ASE SDC

CR:547010

CR Number:   547010 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.2 ESD#6 Fixed Version Build Resolution Date Closure Code (If Appropriate) 28 Sep 2011 Duplicate Description It would be useful to have an MDA table to report on use of stored procedures, including execution count, last execution time etc Workaround Description  N/A

CR:547023

CR Number:   547023 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   HP-UNIX Original Version:   15.0.2 ESD#5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 Mar 2009 Not reproducible with latest version of the product available as of Resolution Date Description DBCC CHECKSTORAGE reports faults 100009, 100029, and 100030 on the sysanchors table.

CR:547114

CR Number:   547114 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 05 Aug 2010 Fixed Description Currently if more than one cluster is configured on a machine, the port ranges will need to be manually edited in the Sybcluster XML file. So, enhance the function of creating cluster to allow user enter starting port.

CR:547118

CR Number:   547118 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 May 2009 Fixed 20 May 2009 Reservation Made 25 May 2009 Fixed 07 Feb 2011 Added to user documentation 04 Sep 2009 Insufficient priority to fix 30 Aug 2009 Fixed Description A new builtin function is_singleusermode is created to determine if server is in single-user mode. sp_downgrade will force the server to be in single-user mode before downgrade is performed.

CR:547182

CR Number:   547182 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.1 ESD #4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 24 Oct 2008 Fixed Description If there is instance-specific configuration in blocks before the 'default data cache' group, error 5890 will be raised. This is caused by the config file format not recognized by file reader interfaces.

CR:547288

CR Number:   547288 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.1 ESD #4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 22 Oct 2008 Duplicate Description Under rare circumstances, the message "current process infected with 11" in the module 'cm_cid_from_name' while creating named cache.

CR:547300

CR Number:   547300 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.0.2 ESD#5 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Allow identity() on derived tables.

CR:547350

CR Number:   547350 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.2 ESD#6 Fixed Version Build Resolution Date Closure Code (If Appropriate) 24 Oct 2008 Fixed Description Explicit conversion from 1.0 to unichar(1) returns wrong result and no error raised.

CR:547361

CR Number:   547361 Product Name:   Adaptive Server Enterprise Product Component:   sybmigrate Status:   Closed OS:   all Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Mar 2009 Fixed 25 Jul 2010 Fixed Description Whenever SybMigrate experiences any problems making a connection to either the source or destination ASE it always prints the same error: ERROR|The URL 'bruno-xp:5000' has an incorrect format. The correct format is: <hostname>:<port number>. This is very misleading.

CR:547375

CR Number:   547375 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 01 Feb 2009 Fixed 19 Jan 2009 Reservation Made 23 Feb 2009 Fixed Description This feature provides the ability for a user to set the sql statement replication threshold at the ASE session level using the syntax: set repthreshold <value>. Workaround Description  N/A.

CR:547432

CR Number:   547432 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   12.5.4 ESD#7 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Enable deadloack detection between ASE structures

CR:547476

CR Number:   547476 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.2 ESD#6 Fixed Version Build Resolution Date Closure Code (If Appropriate) 21 Oct 2008 Fixed Description hostid() retuns unexpected trash data

CR:547492

CR Number:   547492 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   pyxis Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Feb 2009 Fixed 21 Jan 2009 Fixed 29 Jan 2009 Fixed 20 Jan 2009 Fixed 15 Jan 2009 Fixed 02 Feb 2009 Fixed 14 Jan 2009 Fixed 30 Jan 2009 Fixed 21 Jan 2009 Fixed 13 Jan 2009 Fixed 20 Jan 2009 Fixed 05 Feb 2009 Fixed 29 Jan 2009 Fixed 20 Jan 2009 Fixed 27 Jan 2009 Fixed 09 Feb 2009 Fixed Description Internal only: replace code references to datatypes SYB_LONG and SYB_ULONG with other, more appropriate types.

CR:547572

CR Number:   547572 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.2 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Nov 2008 Fixed Description The SQL text wasn't being printed for query's that went through terminate_process(). This is a very useful diagnostic. The query text printing has been reinstated.

CR:547622

CR Number:   547622 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.2 ESD#6 Fixed Version Build Resolution Date Closure Code (If Appropriate) 24 Oct 2008 Fixed 22 Oct 2008 Fixed 15 Jun 2009 One-off Provided 30 Jun 2009 One-off Provided 07 Jul 2009 One-off Provided Description Adhoc batch may be silently aborted if it creates a temporary table and a clustered index on this table. Workaround Description  use tempdb..tmp1 instead of #tmp1 like following :- 1> create table tempdb..tmp1(a int) 2> create clustered index idx1 on tempdb..tmp1(a) 3> select * from tempdb..tmp1 4> go a ----------- (0 rows affected)

CR:547699

CR Number:   547699 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   Solaris Original Version:   15.0.2 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description In the default unchained mode, a trigger that contains an unmatched commit causes a batch of similar statements then effect that trigger to complete without all statements executing. Workaround Description  Use set chained off before executing the batch of commands. Remember to set this back again after the batch is complete.

CR:547700

CR Number:   547700 Product Name:   Adaptive Server Enterprise Product Component:   diagserver Status:   Closed OS:   AIX Original Version:   15.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 09 Nov 2008 Fixed 26 Nov 2008 Bundled Request 17 Feb 2009 Fixed Description under certain circumstances, ASE 15.0.3 on AIX encounter a hang with following messages in the errorlog. kernel PCI(M1): ERROR: JNI_CreateJavaVM; failed retrieving the JVMTI handle in GetEnv() with -4 kernel PCI(M1): ERROR: JNI_CreateJavaVM; PCA/VM FAILED; not enough memory kernel PCI(M1): ERROR: jsigcache_destroy; Signature cache destroy request without a JavaVM handle to destroy kernel PCI(M1): -> PCA/JVM Signature cache is detached kernel PCI(M1): Failed to destroy the VM signature cache. Workaround Description  No known workaround to prevent the problem. Restart ASE if the server hangs due to this bug.

CR:547741

CR Number:   547741 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX Original Version:   15.0.2 ESD#5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 24 Oct 2008 Fixed 12 Nov 2008 Fixed 11 Nov 2008 One-off Provided 06 Feb 2009 Presently Not Targeted For Any Future Release Of This Product 30 Mar 2009 One-off Provided Description Under some circumstances a stored procedure execution which aborts with certain errors (like, for example, a 226 error "... command not allowed within multi-statement transaction.") could unexpectedly close the tables used by the session who previously executed the same stored procedure. Workaround Description  Difficult to say, but in this specific 804 case try detect why 226 error is raised and try eliminate this from happening.

CR:547749

CR Number:   547749 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.2 ESD#6 Fixed Version Build Resolution Date Closure Code (If Appropriate) 23 Mar 2009 Fixed Description The 857 error was changed to include user defined temporary databases, but the wording of the error message is confusing customers who are not trying to bind a user defined tempdb.

CR:547752

CR Number:   547752 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 06 Nov 2008 Fixed 30 Mar 2009 Fixed Description On Solaris platform, an ASE task may be terminated with a timeslice error while issuing an asynchronous i/o. This is caused by a hang in the operating system, and can lead to recovery errors in Adaptive Server. Adaptive Server has been modified to avoid terminating the task, and will print an informational message instead. Recovery errors will be avoided, but ASE engine will hang until the operating system responds.

CR:547756

CR Number:   547756 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 document error 857 in the Troubleshooting Guide

CR:547757

CR Number:   547757 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.2 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 21 Dec 2010 Fixed Description Error 559 and 3702 could be raised when executing a stored procedure if set fmtonly is on.

CR:547774

CR Number:   547774 Product Name:   Sybase ETL Product Component:   GUI Status:   Closed OS:   all Original Version:   4.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 25 Nov 2008 Added to user documentation Description Problem: When installing on a machine that has ETL installed or if previously installed and uninstalled, the initial automatic login to the repository fails. Workaround: User can successfully log on by manually providing the password (transformer).

CR:547824

CR Number:   547824 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX 5.1 Original Version:   15.0.2 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 Dec 2008 Fixed 04 Feb 2009 Fixed 02 Mar 2009 Fixed Description The message "process infected with signal 11" in the module 'bufdlink' may be reported in the error log together with a stack trace which includes the modules 'pg_allocate' and 'bufdirty' when a stored procedure is executed requiring a work table creation and cache binding for user temporary databases was changed between executions. This will result in ASE shutting down itself. Workaround Description  Avoid cache binding changes for user tempdb's on a live ASE system. All other in-directly cache binding change might also cause problem (e.g., sp_tempdb). See CR 554653 for more detail.

CR:547839

CR Number:   547839 Product Name:   Adaptive Server Enterprise Product Component:   Pluggable_JVM Status:   Closed OS:   Microsoft Windows NT Original Version:   15.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 26 Feb 2009 Fixed 01 Apr 2009 Fixed 23 Mar 2009 Presently Not Targeted For Any Future Release Of This Product Description The ASE/PCI dispatching system on Windows randomly reports various synchronisation failures, which may include: PCI(T0): ERROR: pci_wakeup; Unable to wakeup slot: 00, sema: 25DCAA74->(0), value: 0 and usually ends with: PCI(T0): ASE_PCI: PCI Launcher Boss thread died. This is a FATAL ERROR (errno = -1) and then usually a stack trace. After this, no java operations work although other ASE operations may continue normally.

CR:547890

CR Number:   547890 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   Solaris Original Version:   15.0.2 ESD#5 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description -T364 is available for compatibility mode to use range density instead of total density to estimate join clause selectivity. Previous CR number is 214984. Compatibility mode has its limitation and cannot apply to queries using new features. Request enhancement of -T364 to let 15.x native optimizer support this trace flag on server level and provide a new criteria for session level. Workaround Description  1. Use an abstract plan via plan clause to provide hints to the optimizer: plan '( sort ( nested ( nl_join ( i_scan location_avail_confid_idx ( table ( la t_location_availability ) ) ) ( i_scan PK_LOCID ( table ( l t_location ) ) ) ) ( subq ( scalar_agg (nl_join (i_scan location_mtg_locid_idx t_location_meeting) (i_scan PK_MTGID t_meeting))))) ) ( prop ( table ( la t_location_availability ) ) ( parallel 1 ) ( prefetch 2 ) ( lru ) ) ( prop ( table ( l t_location ) ) ( parallel 1 ) ( prefetch 2 ) ( lru ) ) ( prop t_meeting ( parallel 1 ) ( prefetch 2 ) ( mru )) ( prop t_location_meeting ( parallel 1 ) ( prefetch 2 ) ( lru ) )' Or 2. Reduce the total density via sp_modifystats t_location_meeting, 'location_id', MODIFY_DENSITY, total, absolute,smaller_value (customers need to test their applications to make sure no negative side effect for other queries).

CR:548000

CR Number:   548000 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.2 ESD#6 Fixed Version Build Resolution Date Closure Code (If Appropriate) 10 Nov 2008 Fixed 11 Nov 2008 Reservation Made Description UPDATE and DELETE queries that contain correlated existence subqueries, such as: update tab1 set col1 = 5 where exists (select 1 from tab2 where tab2.col2 = tab1.col2) may sometimes be executed in deferred update mode when it is possible to use direct update mode, resulting in a performance regression.

CR:548069

CR Number:   548069 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.2 ESD#6 Fixed Version Build Resolution Date Closure Code (If Appropriate) 03 Nov 2008 Fixed 03 Nov 2008 Reservation Made Description 'set compatibility_mode on/off' is introduced to enable/disable compatibility mode at session level.

CR:548137

CR Number:   548137 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.2 ESD#6 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Feb 2009 Fixed Description Under certain circumstances an error is reported when an invalid data type conversion is attempted, leading to a stack trace as the failed conversion causes an invalid function pointer to be referenced. Workaround Description  The workaround is to avoid invalid cast operations. In the clients case, converting a date to an integer format, I would recommend adding the three parts of the date together to produce a single integer value: select * from foo where a=datepart(year,'2008-10-21')*10000 + datepart(month,'2008-10-21')*100 + datepart(day,'2008-10-21')

CR:548150

CR Number:   548150 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 Feb 2009 Fixed Description CHECKSTORAGE incorrectly reports error 9960, 'A non-recoverable error has occurred in the CHECKSTORAGE operation. The operation has been aborted.' at a fatal severity level of '20' when the user aborts the CHECKSTORAGE operation.

CR:548188

CR Number:   548188 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.2 ESD#6 Fixed Version Build Resolution Date Closure Code (If Appropriate) 09 Dec 2008 Fixed Description A 7139 error, "Insert to a TEXT/IMAGE column from a non TEXT/IMAGE field which involves internal worktable (eg. orderby, groupby) processing is not supported. Rewrite your query to avoid conversion from non TEXT/IMAGE datatype to TEXT/IMAGE datatype." maybe be reported when executing a query involving an explicit NULL value being converted to TEXT/IMAGE datatype.

CR:548200

CR Number:   548200 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.1 ESD #4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 09 Jan 2009 Fixed Description After loading a 12x server based database and transaction dump into a 15x server, when we try to online the database, server could throw error 4218, 692.

CR:548207

CR Number:   548207 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   pyxis Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Nov 2008 Fixed 09 Nov 2008 Fixed Description Enable IBM MQ DMP feature work.

CR:548235

CR Number:   548235 Product Name:   Adaptive Server Enterprise Product Component:   backup server Status:   Closed OS:   all Original Version:   15.0.2 ESD#6 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16 Jul 2009 Fixed 22 Jul 2009 Fixed Description When a dump database command is performed on an ASE that uses the sjis charset and the Backup Server is using the eucjis charset, then the Backup Server reports an Open Server message of "Open Server Error: 16368.10.0.0 srv_senddone(): A message was initialized, but not completed" and the dump database command does not respond. Workaround Description  Use sjis charset for Backup Server.

CR:548251

CR Number:   548251 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   12.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Request to check the transaction log is valid early in the load process, in order to fail earlier is the log is invalid or corrupt. Workaround Description  N/A

CR:548257

CR Number:   548257 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.4 ESD#8 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Nov 2008 Fixed 21 Nov 2008 Fixed 05 Dec 2008 Fixed Description Error 11141 is reported in the errorlog when Adaptive Server fires a threshold procedure that requires sso_role and when a password has been attached to sso_role. The threshold procedure is successfully invoked.

CR:548266

CR Number:   548266 Product Name:   Adaptive Server Enterprise Product Component:   backup server Status:   Open OS:   all Original Version:   15.0.2 ESD#5 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description XPDL: New Feature Request for load to report percentage of pages converted for example: Cross-platform conversion for database bigTest: 30401 pages completed (10%). Workaround Description  n/a

CR:548330

CR Number:   548330 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   pyxis Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Dec 2008 Fixed 22 Jan 2009 Fixed 22 Jan 2009 Fixed Description In rare cases, a 6909 error could be raised and shutdown the server when the first log record for a chained transaction is written to the log.

CR:548336

CR Number:   548336 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.2 ESD#6 Fixed Version Build Resolution Date Closure Code (If Appropriate) 24 Mar 2010 Fixed Description When you set tracefile and then try to write a query plan into the trace file, Application Tracing doesn't write a carriage return ("\n") with japanese messages. That's hard to read the query plan in the trace file.

CR:548411

CR Number:   548411 Product Name:   Adaptive Server Enterprise Product Component:   sqlloc Status:   Closed OS:   all Original Version:   15.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 05 Nov 2008 Fixed Description sqlloc will show error when setting default language to English and setting default charset to gb18030.

CR:548414

CR Number:   548414 Product Name:   Adaptive Server Enterprise Product Component:   DBISQL Status:   Closed OS:   all Original Version:   15.0.2 ESD#6 Fixed Version Build Resolution Date Closure Code (If Appropriate) 30 Jan 2009 Fixed Description When displaying results in DBISQL using Text Output mode the row count is not displayed on the status bar. Workaround Description  N/A

CR:548417

CR Number:   548417 Product Name:   Adaptive Server Enterprise Product Component:   DBISQL Status:   Open OS:   all Original Version:   15.0.2 ESD#6 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description DBISQL Feature request for accessing the Tools-> Options dialog directly via the toolbar Workaround Description  N/A

CR:548419

CR Number:   548419 Product Name:   Adaptive Server Enterprise Product Component:   DBISQL Status:   Closed OS:   all Original Version:   15.0.2 ESD#6 Fixed Version Build Resolution Date Closure Code (If Appropriate) 06 Nov 2008 Fixed Description Change DBISQL User Interface to allow configuring on a per window basis (i.e. Text mode in one window, Grid mode in another) without having to launch windows from the start menu separately. Workaround Description  Launch windows from the start menu separately.

CR:548420

CR Number:   548420 Product Name:   Adaptive Server Enterprise Product Component:   DBISQL Status:   Closed OS:   all Original Version:   15.0.2 ESD#6 Fixed Version Build Resolution Date Closure Code (If Appropriate) 06 Nov 2008 Fixed Description In DBISQL it is currently not possible to select/copy a range of cells (such as rows 2, 3 & 4 columns db_size and owner) or select non-sequential rows (such as rows 2, 4 & 6). Workaround Description  Change query so that the results match the range of cells / columns that need to be copied.

CR:548422

CR Number:   548422 Product Name:   Adaptive Server Enterprise Product Component:   DBISQL Status:   Closed OS:   all Original Version:   15.0.2 ESD#6 Fixed Version Build Resolution Date Closure Code (If Appropriate) 30 Oct 2008 Fixed Description In GRID output mode, DBISQL 9.0.2 does not all resorting data (by Column) after it has been retrieved. Sorting is now provided in DBISQL 11. Workaround Description  Sort/Re-sort data using clauses in the query.

CR:548423

CR Number:   548423 Product Name:   Adaptive Server Enterprise Product Component:   DBISQL Status:   Closed OS:   all Original Version:   15.0.2 ESD#6 Fixed Version Build Resolution Date Closure Code (If Appropriate) 10 Nov 2008 Fixed Description When selecting File --> New , DBISQL issues no warning that you are about to lose all the SQL that you currently have in the window. This is a feature request to put in place a prompt to save the SQL data.

CR:548487

CR Number:   548487 Product Name:   Adaptive Server Enterprise Product Component:   DBISQL Status:   Closed OS:   Windows XP Original Version:   15.0.2 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 May 2009 Fixed Description searching through the pull down menu ... edit, find/replace ... works in the SQL Statement pane but searching through the same pull down menu fails when the Results pane is highlighted.

CR:548500

CR Number:   548500 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.4 ESD#7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 06 Jan 2009 Fixed 07 Jan 2009 Fixed 06 Aug 2009 Presently Not Targeted For Any Future Release Of This Product Description The recovery task may appear to hang forever executing the functions 'redo_apl_oaminsert', 'pg__updateoam_thru_allocpg' and 'pg__recalc_oamentry' after loading a database dump which was taken on a very active ASE environment.

CR:548559

CR Number:   548559 Product Name:   Adaptive Server Enterprise Product Component:   DBISQL Status:   Closed OS:   Windows XP Original Version:   15.0.2 ESD#5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 30 Jan 2009 Fixed Description Previously in DBISQL 9.0.2 if a large amount of rows were copied to the clipboard, a stack trace would occur. The behavior has been modified in DBISQL 11.0.0 so that a friendly message ("There is not enough memory to copy the selected values") is shown instead.

CR:548560

CR Number:   548560 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) 20 Feb 2009 Fixed Description Commands 'raiserror' and 'print' do not work with unichar and univarchar parameters. Workaround Description  None known.

CR:548568

CR Number:   548568 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) 08 May 2009 Duplicate Description Feature Request: Add a "Result Set" Cache to ASE.

CR:548593

CR Number:   548593 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Microsoft Win32s Original Version:   15.0.2 ESD#5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 21 Oct 2013 Fixed Description Updating a TEXT value into a proxy TEXT column using the value from a local TEXT column results in garbage being inserted. Workaround Description  None known.