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

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

CR:543377

CR Number:   543377 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) 24 Oct 2008 Fixed 24 Oct 2008 Reservation Made 27 Oct 2008 Fixed Description Add a new dynamic configuration parameter 'enable compatibility mode' to enable/disable compatibility mode. The default value is 0 (disabled).

CR:543499

CR Number:   543499 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   12.5.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 25 Sep 2008 Fixed 20 Oct 2008 Fixed Description Under certain circumstances, a create index with sorted data on a table may result into a 623 error

CR:543528

CR Number:   543528 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 Request to update the documentation with an explanation for error 14127. Before dropping or modifying a partition, Adaptive Server Enterprise verifies that the user process has exclusive access to the partition descriptor. If it does not the command fails and a 14127 error is raised.

CR:543594

CR Number:   543594 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX 5.1 Original Version:   15.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 09 Oct 2008 Fixed Description The wrongpage error may be reported in the error log followed by a stack trace in module text_tabcheck when running dbcc checktable after altering table change lock, which also follows runtime undoing a dml transaction on the same table in a remote node.

CR:543622

CR Number:   543622 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UNIX Original Version:   15.1 ESD #4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Oct 2008 Fixed 24 Oct 2008 Fixed Description The default "max memory" is insufficient. Enlarge the default value of "max memory".

CR:543627

CR Number:   543627 Product Name:   Adaptive Server Generic Docs Product Component:   Other Status:   Closed OS:   all Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 24 Aug 2009 Added to user documentation Description The use of Open Single Quote and Close Single Quote in documentation results in the inablilty to cut and paste commands from the manual without carefully editing each command to ensure syntactical correctness. Workaround Description  All sample statements must be checked before being executed to ensure that the correct quotation marks are used in the pasted version of the command.

CR:543629

CR Number:   543629 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 Sep 2008 Presently Not Targeted For Any Future Release Of This Product Description In rare circumstances, task executing "drop index" may deadlock on system tables, with other tasks executing DDLs and utility command on the same database.

CR:543639

CR Number:   543639 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.2 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 Sep 2008 Fixed Description Using "bcp in" to a table whose specified name (database + owner + table name) exceeds 255 bytes will fail with no error message from ASE.

CR:543642

CR Number:   543642 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) 19 Nov 2008 Fixed Description Msg 325 (no plan found) in ASE 15 may happen on join involving a DISTINCT view and one of the DISTINCT view SELECT column has an equisarg on it. Workaround Description  set opportunistic_distinct_view 0 It disables opportunistics DISTINCT handling in optimizer and reverts back to the similar DISTINCT handling in pre-galaxy optimizer.

CR:543650

CR Number:   543650 Product Name:   System Admin Guide Product Component:   System Administration Guide Status:   Open OS:   NA Original Version:   6.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description From the System Administrator Guide, Page 116 on IOR object references: The name server uses the selected load distribution policy and generates an IOR with multiple profiles to balance the request between available servers and ports. If a dynamic load policy is selected, the NLL is used to determine and balance the load of the individual servers. There is no longer a way to select the 'load policy' for a cluster.

CR:543705

CR Number:   543705 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Microsoft Windows NT Original Version:   15.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 09 Jan 2009 Fixed Description On Windows, if an ASE task has been using java and subsequently encounters a stack overflow, the stack overflow is not correctly cleaned up and renders the java system non-operational.

CR:543800

CR Number:   543800 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 Sep 2008 Fixed Description A search with a equality clause comparing an INT column with a literal numeric that exceeds MAXINT incorrectly returns rows.

CR:543801

CR Number:   543801 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 Feature request to, in order to reduce the number of indexes, allow new unique constraints to be implemented using any existing index that has that column as the leading column of the index.

CR:543817

CR Number:   543817 Product Name:   Adaptive Server Enterprise Product Component:   MonitorServer Status:   Closed OS:   all Original Version:   15.0.2 ESD#5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 08 Dec 2008 Fixed 05 Jan 2009 Fixed 03 Feb 2009 Fixed Description Monserver reports events lost in monserver errorlog after upgrading to 15.0.2 ESD#2. Workaround Description  boot monserver binary from ESD1

CR:543861

CR Number:   543861 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 In a multi-node cluster, in rare circumstances, lock promotion settings for a row-locked table could be incorrect.

CR:543871

CR Number:   543871 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) 23 Mar 2009 Fixed Description Set resource_granularity give error messages Invalid pointer param number 1 if you try a higher value than what is set with sp_configure "max resource granularity". Workaround Description  Use the Serverwide. sp_conifgure "max resource granularity"

CR:543877

CR Number:   543877 Product Name:   Adaptive Server Enterprise Product Component:   InstallShield Status:   Closed OS:   all Original Version:   15.0.2 ESD#5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 25 Mar 2010 Fixed 12 May 2010 Not a Bug Description When you install ASE 15.0.2 ESD5 and select "Update" as Install Type to update all installed ASE components, the installer should determine the installed components and update them to the latest available versions. But the installer may additionally install the following connectivity components even if those are not installed components. o Embedded SQL/C o Monitor Client Library o XA Interface Library for ASE Distributed Transaction Manager o Connectivity Language Modules for chinese, japanese, spanish, french, korean, polish, thai, german and portuguese. Workaround Description  Use "Custom" install type.

CR:543904

CR Number:   543904 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) 14 Jan 2009 Fixed 13 Jan 2009 Duplicate pyxis 18 Mar 2009 Fixed 15 Jan 2009 Fixed 19 Jan 2009 Fixed pyxis 17 Mar 2009 Fixed Description Database recovery statistics are available only if recovery of that database is in progress. With this fix, most recent database recovery statistics will be available through monDBRecovery, monDBRecoveryLRTypes and monFailoverRecovery MDA tables.

CR:543930

CR Number:   543930 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.0.2 ESD#5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 01 Oct 2008 Fixed 05 Nov 2008 One-off Provided Description ASE failed to disable mirror device if error occurred while opening the mirror device.

CR:543973

CR Number:   543973 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.2 ESD#5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 29 Oct 2008 Fixed Description When statement cache is turned on, a query that meets the following conditions: 1> union 2) subquery on one side of the union, 3) derived table expression under subquery, 4) there are local variables in derived table expression, 5) there are builtin functions in derived table expression, may cause stack trace to happen in LeEvRun(). Workaround Description  1) Use IF467 when turning statement_cache ON. Or 2) Turning statement_cache OFF

CR:544007

CR Number:   544007 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) 13 Apr 2009 Fixed 13 Apr 2009 Reservation Made 13 Apr 2009 Fixed Description In rare circumstances, DBCC CHECKVERIFY command could result in error 12921 due to the task hitting deadlock. Message 1205 would be also be reported for the task in the errorlog.

CR:544112

CR Number:   544112 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.0.2 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 Sep 2008 Fixed Description Queries that use a partition table (call it PT) and contain a SARG against PT on a non-partitioning column may return too few rows. The query must also contain a SARG against PT's partitioning columns such that some partitions can be eliminated during optimization. Take the following query as an example: select * from S inner join PT on S.c1 = PT.npc and PT.pc >= 1 The predicate "PT.pc >= 1" can be used to eliminate some partitions during code generation (pc is PT's partitioning column). The equijoin "S.c1 = PT.npc" is a SARG against one of PT's non-partitioning columns. In this case, once S.c1 has a value of NULL, no more rows will be returned from this equijoin even after S.c1 is refreshed to non-NULL value. Note that this problem could also occur across stored procedure or cached statement invocations.

CR:544182

CR Number:   544182 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) 16 Oct 2008 Fixed 10 Mar 2009 Fixed Description Stored procedure creating tables with materialized computed columns and inserting data into those tables may return unexpected errors like error 515 "Attempt to update or insert row failed because resultant row of size larger than the maximum size allowed for this table." This problem may happen only if the procedure requires renormalization because some objects referenced by it were dropped and recreated.

CR:544183

CR Number:   544183 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) 16 Oct 2008 Fixed Description Stored procedure may fail with errorlog reporting modules:pre__substitute_fi_cpc,pre__replace_cpc, s_getTreeOrPlan,open_user_table,open__byname,parse_name. This may happen if procedure creates a table with computed column.

CR:544228

CR Number:   544228 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) 07 Oct 2008 Fixed 21 Oct 2008 One-off Provided 29 Jan 2009 Bundled Request Description jConnect and Data Drivers are unable to login to ASE 15.0.2 with encrypted logins if the ASE password has expired.

CR:544256

CR Number:   544256 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX Original Version:   15.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Oct 2008 Fixed 13 Oct 2008 Fixed 04 Aug 2009 Presently Not Targeted For Any Future Release Of This Product Description On some platforms a stack trace in n3__make_jsig() may result when a sqlj procedure is created with more than the allowable number of parameters and there is a matching java function intsalled on the server.

CR:544258

CR Number:   544258 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) 28 Jan 2009 Fixed Description Attempts to use a database from a node N2 while it was created with the 'for load' clause on a node N1 does not return the expected 930 error message.

CR:544289

CR Number:   544289 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 auto update statistics.

CR:544360

CR Number:   544360 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) 07 Oct 2008 Fixed 20 Mar 2009 One-off Provided Description A large statement that is over 16k and contains a lot of white spaces may not be cached in the statement cache. Workaround Description  trim whitespace from query by hand

CR:544373

CR Number:   544373 Product Name:   Adaptive Server Enterprise Product Component:   optdiag Status:   Closed OS:   all Original Version:   15.0.2 ESD#5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 21 Oct 2008 Not reproducible with latest version of the product available as of Resolution Date Description

CR:544376

CR Number:   544376 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 Feature Request sp_shmdumpconfig to dump to multiple devices for each thread

CR:544485

CR Number:   544485 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) 25 Nov 2008 Fixed Description Subqueries that join with a column from a "distinct" view or derived table will not mark the joining predicate as a sargable. This could result in a cartesian product scan rather than an index lookup. Workaround Description  The problem is a side-effect of the opportunistic distinct view feature. Use "set opportunistic_distinct_view off".

CR:544498

CR Number:   544498 Product Name:   Adaptive Server Enterprise Product Component:   MDA/Monitoring Tables Status:   Closed OS:   all Original Version:   15.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16 Jun 2009 Fixed 18 Jun 2009 Fixed Description diagserver could run into an assertion fail when 'enable stmt cache monitoring' is active. Workaround Description  disable 'enable stmt cache monitoring'.

CR:544589

CR Number:   544589 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 Sep 2008 Bundled Request Description If CIS and java features are enabled in ASE 15.0.3, JVM and all CIS connections are affinitied to the same engine. This results in OMNI connections not distributed across the engines that can potentially cause performance degradation.

CR:544633

CR Number:   544633 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 Optimizer doesnt consider certain query plans for large queries, which could result in suboptimal query plans. Workaround Description  Recreating the view hiddenStrategies to use group by clause instead of distinct clause should address this issue: create view hiddenStrategies as select a.strategyName from pnlBoxGroups a, pnlBoxGroupAttributes b where a.groupName = b.groupName and b.flags & 256 != 0 and a.strategyName != null group by a.strategyName go

CR:544667

CR Number:   544667 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) 20 Jul 2009 Fixed Description If the dataserver is configured with 1 SSL listener and the server ssl certificate is bad the dataserver will continue to start with no valid listeners. Workaround Description  Kill the dataserver via the task manager. Start the dataserver without ssl enabled. Use sp_ssladmin 'dropcert' to drop the certificate. Add a good certificate with sp_ssladmin 'addcert'. Enable SSL and reboot.

CR:544679

CR Number:   544679 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.2.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 30 Sep 2008 Fixed 30 Sep 2008 Fixed Description Executing UPDATE queries involving NULL LOBs may hit error 691, "Encountered invalid logical page 0 ..." with a stack trace in the modules 'updtext()' and 'wrongpage()'.

CR:544704

CR Number:   544704 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) 01 Oct 2008 Fixed 10 Nov 2008 Fixed Description The query below may return 0 row if FKcol1 and FKcol2 columns on table B are character variable-width, nullable datatypes and col1 and col2 columns on table A are character fixed-width, non-nullable datatypes. select B.FKcol1 + ',' + B.FKcol2 from A, B where B.FKcol1 + ',' + B.FKcol2 = 'TEST5,T' and A.col1 = B.FKcol1 and A.col2 = B.FKcol2 Workaround Description  Use a character variable-width, nullable datatype for required join columns. Or convert fixed-width columns to varchar datatype or use rtrim() to trim trailing blanks.

CR:544748

CR Number:   544748 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Jan 2009 Fixed Description The message "closetable: table already closed for sdes <value>" may be reported in the error log together with a stack trace which includes the modules 'pg_allocate' and 'pg_allocoam' after an 1105 error is reported during page allocation.

CR:544818

CR Number:   544818 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 Jan 2009 Fixed Description Wrong result (missing rows with NULL values) could happen for sybase extended column groupby query (i.e. SELECT more columns than the Group By list and aggregate) when one of the joining view/derived table has DISTINCT. Workaround Description  traceflag 15387 to turn off MATCHNULL tcid join.

CR:544845

CR Number:   544845 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UNIX Original Version:   tyresias Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Oct 2008 Fixed 14 Oct 2008 Reservation Made Description When statement cache and literal autoparam are enabled, a query with intensive numeric computation may cause error 3624 "Truncation error occurred" to be raised. Workaround Description  Workaround 1: set literal_autoparam off go update .... go Workaround 2: set arithabort numeric_truncation off go update ... go

CR:544873

CR Number:   544873 Product Name:   Adaptive Server Generic Docs Product Component:   To Be Determined Status:   Open OS:   all Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Job Scheduler users guide needs to document all available proerties for jobs

CR:544889

CR Number:   544889 Product Name:   Adaptive Server Enterprise Product Component:   JVM Status:   Closed OS:   all Original Version:   15.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 Mar 2009 Fixed 19 Mar 2009 Fixed Description If CIS and java features are enabled in ASE 15.0.3, JVM and all CIS connections are affinitied to the same engine. This results in OMNI connections not distributed across the engines that can potentially cause performance degradation. Workaround Description  If Java in Database feature is not used together with CIS feature, -T 9403 traceflag can improve the performance by distributing CIS connections across all the ASE engines. If you are not sure if CIS and Java feature are not used together, DO NOT ENABLE -T 9403 as this can lead to a stacktrace.

CR:544904

CR Number:   544904 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) 15 Oct 2008 Fixed 25 Oct 2008 Fixed Description In rare circumstances, sysmon report may show negative values under task management section.

CR:544936

CR Number:   544936 Product Name:   Adaptive Server Generic Docs Product Component:   System Administration Guide Status:   Closed OS:   all Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 26 Sep 2008 Added to user documentation Description Enhance the SA Guide discussion of the statement cache feature to indicate that substitution of a cached statement causes @@nestlevel to increment.

CR:544992

CR Number:   544992 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.2 ESD#5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Nov 2008 Insufficient priority to fix 17 Nov 2008 Fixed Description DBCC CHECKSTORAGE reports "Msg 15914, 'Failed to bind dbcc named cache <cache name> to the scan workspace <workspace name>.'" if dbcc named cache name contains a space character. Workaround Description  Use data cache with a name that does not include spaces.

CR:545009

CR Number:   545009 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) 14 Oct 2008 Fixed Description In rare circumstances for clusters with two or more instances, it may be possible that bind/unbind cache operation may fail with out error message.

CR:545058

CR Number:   545058 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 26 Sep 2008 Fixed 26 Sep 2008 Fixed 26 Sep 2008 Fixed Description ASE running on Sun Solaris machines which do not have ISM configured within the kernel will cause additional engines to SEGV during their online operation. Workaround Description  Enabling ISM (Intimate Shared Memory) support on the machine and making sure that there are enough available resources for ISM to be allocated will avoid prevent this problem.

CR:545059

CR Number:   545059 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) 31 Oct 2008 Fixed 17 Oct 2008 Reservation Made Description When merge join is disabled, do not include the equi-join columns in the interesting orderings. The optimizer places eagerly Sort operators on the interesting orderings and keeps or discards them based on cost. Although a Sort could also enhance the buffer cache behavior of nested loops join, this comes with some risk due to the substantial cost of sorting and to its blocking nature, specifically when the data volume estimation is wrong (as when costing is based on out of date histograms, magic numbers, etc.). The fix is disabled by trace flag 15338. Workaround Description  Use an AP to force 125x behavior whilst engineering investigates the root cause.

CR:545119

CR Number:   545119 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.0.2 ESD#5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 05 Nov 2008 Fixed 04 Nov 2008 Fixed Description This fixes an issue where server is reporting an error (named cache is configured too small for current demands state 3. Transaction progress may cease) too early.

CR:545130

CR Number:   545130 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.2 ESD#5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 29 Sep 2008 Fixed Description If both expr1 and expr2 are float numbers in 'select isnull(expr1, expr2)'and if precision of expr1 is less than precision of expr2, it returns error msg 247.

CR:545137

CR Number:   545137 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.2 ESD#5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16 Oct 2008 Fixed Description The message "current process infected with 11" in the module 'ssql_update_recompile_info' together with a stack trace which includes the modules 's_getTreeOrPlan' and 'tdsrecv__dynexec' may be reported in the error log and could bring the server down if the configuration options "STATEMENT CACHE SIZE", "ENABLE MONITORING" and "ENABLE STMT CACHE MONITORING" are all enabled and a client application executed a dynamic sql statement with the option "DYNAMIC PREPARE" active and the internal lightweight procedure for the statement had to be recompiled (for example due to a schema change). Workaround Description  Disable "enable stmt cache monitoring" configuration option.

CR:545160

CR Number:   545160 Product Name:   sybcluster Product Component:   Client Status:   Closed OS:   all Original Version:   15.1 ESD #3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 22 Oct 2008 Fixed Description For cluster having two instances on the same node, when the two dataservers are killed externally,the command "start cluster" fails to start the cluster. Workaround Description  (show cluster status you will see status is Up and heartbeat is No) from sybcluster, start cluster fails, but it shows the dataserver commands that it issues) once it fails, go to OS prompt and issue the dataserver command as shown by "start cluster" once that starts, it will correct the status, and you can use sybcluster again.

CR:545162

CR Number:   545162 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) 06 Nov 2008 Fixed 18 Feb 2009 Fixed 16 Nov 2010 Presently Not Targeted For Any Future Release Of This Product Description A large T-SQL unsigned bigint value is incorrectly assigned to a BigInteger Java datatype. For example assiging the value 18446744073709551615 to a BigInteger field in Java will result in a value of -1 being stored in the Java field.

CR:545165

CR Number:   545165 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) 28 Apr 2010 Workaround Description This a feature request to handle situations where we have a lack of statistics due to table data being transient. Clearly there is no current way of maintaining statistics on tables which are only populated potentially during a transaction's lifetime. There needs to be some sort of statistical learning mode to handle this.

CR:545168

CR Number:   545168 Product Name:   Adaptive Server Enterprise Product Component:   InstallShield Status:   Closed OS:   macosx Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Oct 2008 Fixed 20 Oct 2008 Fixed 21 Oct 2008 Fixed 30 Oct 2008 Fixed Description check in Mac OS install related files

CR:545176

CR Number:   545176 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) 24 Jun 2009 Presently Not Targeted For Any Future Release Of This Product 01 Mar 2010 Insufficient info provided 16 Nov 2012 Presently Not Targeted For Any Future Release Of This Product Description 15307 and 15308 traceflags disable the forceplan and hints respectively at a server level. Ther is no way to turn these off at server level and yet enable it at a session level. allow_forceplans and allow_forcehints options provide this ability. Doing 'set allow_forceplans on' would negate the traceflag 15307 in that session. Similarly, 'set allow_forcehints on' would negate the traceflag 15308 in that session.

CR:545180

CR Number:   545180 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) 14 Oct 2008 Fixed 14 Oct 2008 Reservation Made Description Under missing/limited statistics, optimizer might favor a store index (reformatting) plan for a nested loop join even though there is no sarg on the store index child scan and there already exists an index whose keys match the equijoin columns. For most time, based on actual data distributtion, the existing index scan plan would be better. Workaround Description  set store_index 0 --this is in-place now and is acceptable

CR:545181

CR Number:   545181 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.2 ESD#5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 21 Dec 2008 Fixed 10 Feb 2009 Fixed Description A 1129 error may be reported "The requested update to the OAM for object <value>, dbid <value>, index <value>, oam page <value>, would cause a negative page count ... Contact your System Admin." in the error log mistakenly when multiple sessions import data in the same table concurrently through the bulk copy utility. Workaround Description  Make use of trace flag 1133 if possible. When we enter pg__updateoam() if this trace flag is active we will get an EX_LATCH on the first oam page to update the total used/unused pages.

CR:545192

CR Number:   545192 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) 11 Dec 2008 Duplicate Description Complex queries using nested subqueries and or clauses may cause the optimiser not to choose reformatting strategy when it should.

CR:545202

CR Number:   545202 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 If DDL replication is on and we are execute a CREATE SCHEMA which has create views and this CREATE SCHEMA is not in a store procedure could cause 701 errors.

CR:545264

CR Number:   545264 Product Name:   ASE Replicator Product Component:   Distributor Status:   Closed OS:   Generic Original Version:   15.0.3.420P3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.0.3.420P3 01 Oct 2008 Fixed Description ASE REPLICATOR: changing the max_threads configuration parameter has no effect. It always initializes to the default value of 45.

CR:545270

CR Number:   545270 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 Mar 2010 EOL'd version. Not to be Fixed. Description ASE Optimizer may choose the wong join order if WHERE clause has both "<> (not equal to)" and "is not null" on the same column. Workaround Description  set forceplan on

CR:545296

CR Number:   545296 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) 29 Sep 2008 Fixed 01 Oct 2008 Fixed Description QPMetrics are not captured for statements inside a store procedure which is created and compiled before QPMetrics is enabled

CR:545331

CR Number:   545331 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 Sep 2009 Fixed Description ASE Rep Agent support for the Replication Server Normalization Thread feature. Workaround Description  N/A.

CR:545379

CR Number:   545379 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) 22 Oct 2008 Fixed 17 Oct 2008 Reservation Made Description In 12.5.x, the optimizer was not attempting to place reformatting over a table which had an index forced in the FROM clause. The 15.x optimizer did not have this limitation and was always placing and costing StoreIndex (the 15.x operator which implements reformatting) unless a full Abstract Plan was precluding it. When costing is not accurate, for instance due to data skew or to magic numbers based costing when there are no statistics, this could lead to suboptimal plans which were not generated in 12.5.x, hence to performance regressions. This fix re-instate in 15.x the legacy 12.5.x behavior.

CR:545400

CR Number:   545400 Product Name:   Adaptive Server Enterprise Product Component:   JVM Status:   Closed OS:   Solaris Original Version:   15.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 08 Jul 2010 Duplicate Description An ASE configured with PCI based JVM on a Solaris platform may fail to boot when configured with Java in Database feature if JVM requests an extremely large amount of memory due to Solaris bug 6671882. Workaround Description  A workaround fix has been included in ASE 15.0.3 that can handle the incorrect memory request due to miscalculation if the memory size is with in the limits that can be satisfied by the heap memory size on the system. With the workaround fix in ASE, a warning message is printed in the errorlog similar to the following when Solaris bug 6671882 is encountered. kernel PCI(T1): WARNING: pci_malloc; forwarded size 954437177 exceeding max request size 2097072 to the run-time for thread 13

CR:545413

CR Number:   545413 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) 09 Oct 2008 Fixed 20 Nov 2008 Fixed 13 Oct 2008 Fixed 27 Nov 2008 Fixed Description DUMP DATABASE/TRAN with compression may fail with an error, "Length of compressed buffer is greater than the original buffer length".

CR:545416

CR Number:   545416 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.2 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 09 Apr 2009 Fixed Description Occasionally, when ASE write the logfile to dumpfile,"Error: I/O error, errno: 5 "may be reported in the errlog.

CR:545418

CR Number:   545418 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 Oct 2008 Fixed 18 Feb 2009 Fixed Description Loading a Java class with a very large value for a static final defined string can result in a message "infected with 11" with the modules "jvm_GetClassName" and "DBClassFileGetClassName", being printed in the ASE errorlog. Workaround Description  n/a

CR:545428

CR Number:   545428 Product Name:   SySAM Product Component:   FLEXlm Status:   Open OS:   all Original Version:   11.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description SySAM2: Display license usage per platform when using license file with multiple products on different platforms.

CR:545430

CR Number:   545430 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 If a stored procedure contains a begin/commit transaction pair around a create #table statement, and that stored procedure is called from within an existing transaction, then error 277 may occur when executing that procedure. Workaround Description  Avoid including transactions inside trigger/stored procedure code that create temporry tables if that trigger is also called as bazrt of a larger transaction.

CR:545432

CR Number:   545432 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) 02 Feb 2009 Fixed 11 Feb 2009 Fixed Description Support concurrent i/o for VxFS file systems on Solaris and Linux.

CR:545444

CR Number:   545444 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Windows Original Version:   15.0.2 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 25 Nov 2008 One-off Provided 05 Nov 2008 Fixed 06 Nov 2008 Fixed Description Under rare circumstances an ASE system running on a 64 bits Windows Server with a high rate of DML commands executed may result in some data not be written to disk. Workaround Description  [frankl Nov 25 2008] This is related to an incorrect overflow of the dbt_nextseq on win64 when it reaches UINTMAX. Because of this checkpoint will not flush (some of the) dirty buffers to disk. This is not really a workaround, but a way to flush dirty buffers to disk. For version >= 1502 esd#6, you can use dbcc cachedataremove(dbid|dbname, objid|objname, partitionid/partitionname, indid|indexname) otherwise configure sp_configure "housekeeper free write percent", 100 In my test case, this flushed the dirty buffers to disk.

CR:545469

CR Number:   545469 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) 09 Oct 2008 Fixed Description Under heavy load both DBCC CHECKSTORAGE and DBCC CHECKVERIFY can incorrectly detect spurious errors because it could skip a dirty cached page and use the page on disk instead, if the owner instance has got a request to downgrade the physical lock to a null lock.

CR:545489

CR Number:   545489 Product Name:   Adaptive Server Enterprise Product Component:   DBISQL Status:   Closed OS:   Windows W2k Original Version:   15.0.2 ESD#5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 Mar 2009 Bundled Request Description DBISQL 9.0.2 cannot import data into a datetime column because of the message "Can't find type 'TIMESTAMP'". This has been fixed in DBISQL 11.0.0. Also, before DBISQL 11.0.0.1571, importing a char/varchar column would result a syntax error. This has been fixed.

CR:545521

CR Number:   545521 Product Name:   Adaptive Server Enterprise Product Component:   MDA/Monitoring Tables Status:   Closed OS:   all Original Version:   15.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Jan 2009 Presently Not Targeted For Any Future Release Of This Product 23 Jan 2009 Fixed Description For a query that is executed using the clustered index but involves no partitioned table and parallel scan, the value of the UsedCount column of monOpenObjectActivity for IndexID = 1 is not incremented.

CR:545553

CR Number:   545553 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) 01 Oct 2008 Workaround Description Withdrawn feature request for a way to configure the default settings for ARITHABORT at the server level. This can be done with existing functionality by creating a global login trigger that does SET EXPORT_OPTIONS ON SET ARITHABORT NUMERIC_TRUNCATION ON Workaround Description  Note that while not quite as convenient as a single serverwide setting, it is possible to set up a default value using login triggers - you just have to associate the login trigger with each login. use master go create procedure login_trigger as set export_options on set arithabort numeric truncation off go grant execute on login_trigger to public go sp_modifylogin joeuser, "login script", login_trigger go

CR:545558

CR Number:   545558 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 Documentation Bug: The writeup of error 603 indicates a limit of 14 worktables. This limit was raised to 46 in ASE 15.0

CR:545581

CR Number:   545581 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.2 ESD#5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 10 Oct 2008 Fixed Description Wrong results could be returned when a query using a GROUP BY clause is executed, the datatype of the grouping columns is VARCHAR and the data for those columns contains NULL values and empty strings having only white spaces like ' ' Workaround Description  Disable group_hashing for example via "set group_hashing off"

CR:545585

CR Number:   545585 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) 09 Oct 2008 Fixed 06 Dec 2009 One-off Provided Description Unnecessary sort nodes were added to the query plan, which provided no benefits. Normally sort nodes would provide benefits such as orderings for merge join/ORDER BY/GROUP BY, or buffer manager optimization (i.e. better cache hits on an ordered join attribute). This error could occur when there is a combination of multiple covered and non-covered index scans within a query plan. Normally, it occurs in cases when the sorts are very small, so the error is not noticible, since it only involves the estimate of the CPU component. If the sort volume was large, then it would have overwhelmed the incorrect CPU estimate, and the sort would have been eliminated. However, if the input volume estimate for the sort is incorrect, due to missing statistics, and this volume is actually very large, then the addition of the sort operator could result in a noticible performance regression.

CR:545604

CR Number:   545604 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) 15.0.3 22 Oct 2008 Fixed Description Avoid frequent flushing log of index shrink for tables in the tempdb.

CR:545606

CR Number:   545606 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 Oct 2008 Fixed Description This fix keeps the connection level default AP dump/mode active when changing the database. This also makes AP capture more versatile. It is documented that the connection level AP dump/load is disabled when a USE <database> statement is issued, to avoid the tentative usage of an absent user defined AP group. However, when the standard in/out default AP groups are used, there is no reason to disable the connection level dump/load - since these groups are present in all database.

CR:545633

CR Number:   545633 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   all Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Mar 2009 Fixed Description Sybase Central can not connect to ASE if "net password encryption reqd=2" was set on ASE.

CR:545653

CR Number:   545653 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 Oct 2008 Fixed Description The tendency to add expensive sort nodes, solely to break up a nested loop join order has been reduced. This occurs when there are numerous tables in the FROM list, and the optimizer added a sort to break up the join order, so that there is more buffer manager cache available for each side of the sort, that in turn would reduce PIO requirements of the query overall.

CR:545662

CR Number:   545662 Product Name:   Adaptive Server Enterprise Product Component:   MDA/Monitoring Tables Status:   Closed OS:   Solaris Original Version:   One-off Fixed Version Build Resolution Date Closure Code (If Appropriate) 22 Oct 2008 Fixed 08 Dec 2008 Fixed 16 Feb 2009 Fixed 30 Mar 2009 One-off Provided Description Under rare conditions a query on the monOpenObjectActivity MDA table may result in a signal 11 and server crash.

CR:545665

CR Number:   545665 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) 02 Oct 2008 Fixed Description If a server was configured for an ipv6 address 'connect to' would fail. A new syntax is being used to add an ipv6 address in sp_addserver. The syntax will encapsulate the ipv6 address with in brackets '[,]'. An example of an sp_addserver command for an ipv6 address: sp_addserver 'rmtsrv1',ASEnterprise,'[fd77:55d:59d9:167:203:baff:fecd:2b0d]:6268'

CR:545716

CR Number:   545716 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) 14 Feb 2013 Added to user documentation 02 May 2013 Fixed 04 Jul 2013 Fixed 02 May 2013 Added to user documentation 15.7 SP110 17 May 2013 Fixed 07 Jul 2013 Fixed 15.7 SP60 16 Jul 2013 Fixed Description Long Running Transaction against an SAP ASE server can prevent the log being truncated, causing risk of data unavailability for DMLs. Improve how this can be managed.

CR:545718

CR Number:   545718 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) 18 Nov 2008 Duplicate Description Feature request for a method to suppress message "cache is configured too small"

CR:545738

CR Number:   545738 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.0.2 ESD#5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Sep 2010 Insufficient priority to fix Description Outer join query within a stored proc takes 20x longer to run vs ad-hoc query

CR:545741

CR Number:   545741 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) 23 Oct 2008 Duplicate 13 Nov 2012 Fixed Description Fixed by 547741 which was checked into 15.0.3 IR.

CR:545754

CR Number:   545754 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) 20 Oct 2008 Fixed 28 Nov 2008 Fixed Description Application Tracing does not trace actual and estimated I/O statistics when "allow resource limits" configuration parameter is enabled.

CR:545758

CR Number:   545758 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) 21 Dec 2008 Fixed Description Added the display back of "-s" option in the user message when users enable "-s" (sorted) option.

CR:545771

CR Number:   545771 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX Original Version:   15.0.2 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Dec 2008 Fixed 11 Dec 2008 Reservation Made 16 Jan 2009 Fixed Description For DISTINCT query with multiple table join, a lower costing plan with a top DISTINCT operator might be ignored by optimizer. Workaround Description  set opportunistic_distinct_view off

CR:545773

CR Number:   545773 Product Name:   Adaptive Server Enterprise Product Component:   sybmigrate Status:   Closed OS:   all Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 25 Nov 2008 Fixed Description Under some circumstances, SybMigrate may not use the "with sorted_data" option when creating clustered indexes when it could safely do so.

CR:545793

CR Number:   545793 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   12.5.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 04 Aug 2009 DEFER 24 Sep 2012 EOL'd version. Not to be Fixed. Description select returns number instead of "arithmetic overflow" on large number result set. Occurs in Linux 12.5.x - 15.0.2 esd #5 32bit - not 64bit.

CR:545839

CR Number:   545839 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) 08 Oct 2008 Fixed Description When running in a non-English environment, previously Connect Dialog would display an ID if the localized text was not available. This has been fixed so that the English text is displayed instead.

CR:545898

CR Number:   545898 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 Queries involving character conversions may stacktrace when Unilib conversion is enabled.

CR:545900

CR Number:   545900 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 Oct 2008 Fixed 10 Oct 2008 Fixed Description Replication Agent may report the error 9205, state 0, after a cross database transaction happened between two databases and the table or the database is configured to use sql statement replication.

CR:545960

CR Number:   545960 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 Fixed 22 Oct 2008 Fixed Description isnull() builtin on character data could return blank padded data while returning values substituted for nulls