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

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

CR:615923

CR Number:   615923 Product Name:   Adaptive Server Enterprise Product Component:   Job Scheduler Status:   Closed OS:   all Original Version:   aries Fixed Version Build Resolution Date Closure Code (If Appropriate) 07 Feb 2010 Fixed Description When changing the default character set id or changing the default sortorder id, after doing sort order chnages when restart the server, it may hit SIGSEGV.

CR:615978

CR Number:   615978 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Microsoft Windows Original Version:   15.5 ESD #1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 08 Feb 2010 Third Party Problem Description When booting up ASE 15.5 on windows platform by opening a command prompt and executing the Runserver file, an error message is logged indicating that the dll for ldap cannot be loaded. This error does not occur if the server is started as a windows service. Workaround Description  Start the server as a service in Windows rather than from the command prompt using the run server file.

CR:615992

CR Number:   615992 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.5 ESD #1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 Nov 2011 Fixed Description SELECT show_cached_text(<invalid value>) INTO <table> can generate invalid rows and the following query could cause stacktrace.

CR:616005

CR Number:   616005 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.3 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16 Aug 2010 Fixed 16 Aug 2010 Reservation Made 17 Aug 2010 Fixed 17 Aug 2010 Fixed 25 Jul 2013 Insufficient priority to fix Description On a server with a large number of objects the sp_sysmon report may take a long time to complete and report error number 1508. Workaround Description  Running sp_sysmon with the "clear" option has been found to resolve this problem at one customer site.

CR:616168

CR Number:   616168 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.3 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 28 Dec 2011 Fixed Description When running under traceflag 566 to prevent the truncation of trailing blanks during char -> varchar conversion in worktables and during hashing operations, a 102 message, "Incorrect syntax near ','.", may be raised when running sp_sysmon with 'cache wizard'. The error is raised in sp_sysmon_dcachestats. Workaround Description  dbcc traceoff (566) --or Modify sp_sysmon_dcachestats at line 305:- select @cache_size_in_KB = run_size from #syscacheconfig where config=19 and parent=19 and rtrim(name)=@cachename and the statement at line 395 (line 426 specifically) + " and rtrim(name)='" + @cachename

CR:616171

CR Number:   616171 Product Name:   Adaptive Server Enterprise Product Component:   charsets Status:   Open OS:   all Original Version:   15.5 ESD #1 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Feature request: A copy of common.loc and server.loc that can work with 15.5 langinstall

CR:616224

CR Number:   616224 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) 10 Feb 2010 Fixed 04 Feb 2010 Fixed 04 Feb 2010 Fixed 28 Jun 2010 Fixed 22 Mar 2010 Fixed Description Like pattern matching may return fewer rows when the following conditions are met: 1. server's default sortorder is non-binary single-byte sortorder 2. like pattern is a constant literal 3. like pattern string length is the same as column data length 4. column is either varchar or char Workaround Description  1. remove 'lig =' lines in the .srt file if ligatures are not used, this will then require a sort order change and accompanying steps. or 2. enable 'statement cache' and enable literal parameterization of literals in the LIKE clause with traceflag 7739. Certain statements such as 'select into' will not benefit from this workaround.

CR:616415

CR Number:   616415 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.3 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Apr 2010 Fixed Description The message "current process infected with 11" in the module 's_begupdate' together with a stack trace which includes the modules 's_execute' and 'execproc' may be reported in the error log when a stored procedure executes a DML statement which was compiled at runtime and affects a view which had defined an Instead of Trigger. Workaround Description  - Disable "Deferred Compilation" for example using config parameter "procedure deferred compilation" OR - Modify statement so WHERE clause is not using parameters or local variables and therefore Deferred Compilation is not applicable.

CR:616466

CR Number:   616466 Product Name:   Adaptive Server Enterprise Product Component:   sqldbgr Status:   Closed OS:   all Original Version:   bharani Fixed Version Build Resolution Date Closure Code (If Appropriate) 01 Mar 2010 Fixed Description Added SQL Debugger support for new datatypes: 1. Unichar 2. Univarchar 3. Bigtime 4. Bigdatetime

CR:616604

CR Number:   616604 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Windows W2k Original Version:   15.0.3 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 24 Jun 2010 Deferred 24 Jun 2010 Deferred Description Integrated login security on 64-bit NT can produce stacktraces

CR:616783

CR Number:   616783 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UX Original Version:   pyxis Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 Mar 2010 Fixed Description Various issues might show up during cache/pool configuration.

CR:616827

CR Number:   616827 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   Solaris Original Version:   15.0.2 ESD#6 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Signal 11 occurred in lmsort() when update index statistics

CR:616836

CR Number:   616836 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) 18 Feb 2010 Fixed Description DUMP WITH COMPRESSION = 101 may fail with messages Pipe I/O returned 0 bytes followed by Multibuffering subprocesses died

CR:616869

CR Number:   616869 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.3 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Feb 2010 Third Party Problem 03 Aug 2010 Third Party Problem 11 Sep 2012 Fixed Description When a proxy table is accessed through a query limited by either SET ROWCOUNT or the query is aborted through CNTL-C, then a subsequent query to the proxy table will raise a 11206 error, "Unable to connect to server <servername>. Command has been aborted."

CR:617003

CR Number:   617003 Product Name:   Adaptive Server Enterprise Product Component:   Q Configuration Status:   Closed OS:   all Original Version:   15.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Mar 2010 Fixed Description xp_echo.mak make file is incorrectly pointing to libsrv.lib instead of libsybsrv.lib Workaround Description  edit the make file and chage the libsrv.lib to libsybsrv.lib # Nmake macros for building Windows 32-Bit apps !include <ntwin32.mak> all: xp_echo.dll #set the include and library paths ESP_INCDIR=%SYBASE%\%SYBASE_OCS%\INCLUDE ESP_LIBDIR=%SYBASE%\%SYBASE_OCS%\LIB # Update the object file if necessary xp_echo.obj: xp_echo.c $(cc) $(cflags) $(cvars) $(cdebug) -I$(ESP_INCDIR) xp_echo.c # Update the xp_echo.dll if necessary xp_echo.dll: xp_echo.obj $(link) $(linkdebug) -def:xp_echo.def -out:xp_echo.dll \ /libpath:$(ESP_LIBDIR) xp_echo.obj msvcrt.lib shell32.lib libsybsrv.lib

CR:617191

CR Number:   617191 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   all Original Version:   15.0.3 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 21 May 2010 Presently Not Targeted For Any Future Release Of This Product 08 Mar 2010 Fixed Description Sybase Central is unable to recognize and use the OCS interfaces file syntax for commonName handling for SSL of the form: query tcp <host> <port> ssl="CN=<commonName>". Workaround Description  Set up a separate interfaces file for Sybase Central to use. Sybase Central does not care about the commonName so it will handle an entry using ssl but not matching the commonName.

CR:617199

CR Number:   617199 Product Name:   Adaptive Server Platform_Specific Docs Product Component:   Installation Guide for Linux Status:   Closed OS:   all Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 25 May 2010 Added to user documentation Description doc bug: missing manual steps to sybsystemdb syscoordinations table

CR:617227

CR Number:   617227 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 Feb 2010 Fixed 20 Apr 2010 Fixed 21 Apr 2010 Fixed Description Error 8203 may be wrongly raised when doing select into or alter table. The message seen is as follows: Expected to find the descriptor for object %d in database %d in CLONED state.

CR:617372

CR Number:   617372 Product Name:   Adaptive Server Enterprise Product Component:   srvbuild Status:   Closed OS:   Linux Original Version:   15.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 24 Feb 2010 Fixed 20 Feb 2010 Fixed Description When user make use of srvbuild to create monitor server and input invalid value which exceeds the allowed maximum number 20, there is no warning message but task will fail due to can't boot server in the end.

CR:617412

CR Number:   617412 Product Name:   Adaptive Server Enterprise Product Component:   sqlupgrade Status:   Closed OS:   HP-UNIX Original Version:   15.0.3 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 May 2010 Fixed 21 Mar 2010 Fixed 21 Mar 2010 Fixed Description Password should be quoted if it has special characters. Workaround Description  Before starting the upgrade process make sure that the sa password does not contain any special characters.

CR:617420

CR Number:   617420 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   aries Fixed Version Build Resolution Date Closure Code (If Appropriate) 25 Feb 2010 Fixed Description Additional diagnostic information is printed in the error log if the 837 trace flag is on and an 890 error occurs.The diagnostic information is either or both of: log__newpage: Page <pageno> is in DESTROY state prior to bufawrite. plc__flush: Page <page> is in DESTROY state prior to bufpredirty.

CR:617437

CR Number:   617437 Product Name:   Adaptive Server Platform_Specific Docs Product Component:   Install Guide-Adaptive Server Enterprise Status:   Closed OS:   all Original Version:   15.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 25 May 2010 Added to user documentation Description installshield: special character "#" in install path will fail. This should be fixed or documented in the install guide Workaround Description  Do not put the product in a path containing special characters

CR:617459

CR Number:   617459 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.0.3 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Feature request to further automate the process in which the optimal histogram step count is calculated for each object.

CR:617568

CR Number:   617568 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UX Original Version:   pyxis Fixed Version Build Resolution Date Closure Code (If Appropriate) 08 Mar 2010 One-off Provided Description Instrumentation to help find the root cause of Error 3501. The spreading of dbt_dbname field corruption from one instance to other instance is prevented. The DBCC DBTABLE command is enhanced to set a new database name in the DBTABLE on all cluster instances.

CR:617605

CR Number:   617605 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UNIX Original Version:   aries Fixed Version Build Resolution Date Closure Code (If Appropriate) 27 May 2010 Fixed Description Network memory pool is exhausted and authentication fails with message in errorlog: ... ks_falloc: Cannot allocate using ubfalloc(rnetmempool, 8192) Workaround Description  Increase configuration parameter "additional network memory" by 2Mb per engine.

CR:617809

CR Number:   617809 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.3 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 23 Jun 2010 Fixed 12 Jul 2010 Fixed 09 Jul 2010 Fixed Description Update statistics does not allow "with consumers" and "sampling = n percent" to be specified simultaneously. Workaround Description  sp_configure a sample percentage The define the number of consumers. Put sample percentage back to previous value.

CR:617821

CR Number:   617821 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) 11 Feb 2010 Not a Bug Description query doing table scan in 15x instead of OR Strategy (as in 125x ), query performs better using the m_scan hint under the plan clause. Optimizer using Table scan because cost is cheaper than OR Strategy Workaround Description  applying optimizer hint of m_scan as follows: select count(*) from rb_crd_wls_hst where (sync_cd < "S" or sync_cd > "S") plan "(m_scan rb_crd_wls_hst)"

CR:617850

CR Number:   617850 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.3 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 08 Feb 2010 Fixed Description If the client is an old client, pre-15 client, in some rare situation it could get unexpected 103 error message for alter table command when a column name is over 28 bytes. Workaround Description  Trace flag 7717

CR:618177

CR Number:   618177 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   bharani Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Jul 2010 Fixed Description Feature Request: Add replication support for encrypted columns of type Text/Image/Unitext

CR:618191

CR Number:   618191 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.0.3 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description This CR is to look at improving the capture and reporting of the monitor counters surrounding lwp (statement cache) and procedure execution. Currently the figures (which will generally be reported via sp_sysmon) can be a little misleading under certain circumstances.

CR:618219

CR Number:   618219 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.3 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 Mar 2010 Fixed 02 Apr 2010 Fixed Description Wrong result could happen when selecting from a distinct view/derived table over an outerjoin with a WHERE constant equality clause (col=<cnt>) on an outerjoin inner table column and DistinctSorting is in the final plan. This will only effect non-binary sort orders. Workaround Description  set distinct_sorting off --this will result in GroupSorted Distinct directly after the outer join which doesn't suffer the problem. --or set compatibility_mode on

CR:618245

CR Number:   618245 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.3 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 26 Jun 2014 Fixed 26 Sep 2011 Not reproducible with latest version of the product available as of Resolution Date Description UPDATE STATISTICS on a proxy table with a specified column may return error 12814 - "Failed to write information in SYSTABSTATS." Workaround Description  Use traceflag 11229 or import stats by hand using optdiag

CR:618289

CR Number:   618289 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) 02 Mar 2010 Fixed 16 Mar 2010 One-off Provided Description User performing a DROP INDEX is blocked indefinitely by the HOUSEKEEPER CHORES process in what appears to be an undetected deadlock.

CR:618418

CR Number:   618418 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   Aries CE Fixed Version Build Resolution Date Closure Code (If Appropriate) 25 Mar 2010 Fixed Description The store procedure sp_shmdumpconfig might report incorrect values for estimated dump file size for ASE Cluster Edition. Workaround Description  Execute 'set system_view instance' before executing sp_shmdumpconfig. If the convert error is being hit and cluster view is set, then using an instance view may enable the procedure to run (albeit with incorrect values reported).

CR:618451

CR Number:   618451 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 Sep 2012 Fixed Description The message "dbid <dbid> objid <objid> open failed" may be reported when running DBCC EXTENTZAP or EXTENTCHECK on a table that is missing entries in sysobjects. Workaround Description  1) DBCC checkalloc(full,fix) with db in single user mode 2) DBCC fix_al(dbname) with db in single user mode 3) SybEdit extentzap command, db does not have to be in single user mode.

CR:618469

CR Number:   618469 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.3 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 21 Jun 2010 Bundled Request 21 Jun 2010 Bundled Request 12 Sep 2012 Fixed Description The message "Current process ... infected with signal 11 (SIGSEGV)" in module "CgEvals::_CgCompVcol" may be reported in the error log followed by a stack trace during the execution of a query involving UDF/ADT constructions. The modules "jvmfini" and "BRIDGEjvm_AbortJavaVM" will also be reported resulting in the current session terminating and the JVM aborting. Alternatively this may cause ASE shutting down itself. Workaround Description  There is no workaround to this problem. A fix under this CR is required to overcome this problem.

CR:618513

CR Number:   618513 Product Name:   Adaptive Server Enterprise Product Component:   sybmon Status:   Closed OS:   Solaris Original Version:   15.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 Mar 2010 Fixed Description sig 11 is not triggered on recovery of sybystemdb on 15.0.3 upgrade using in place upgrade. It does not stacktrace on dump and load migration of sybsystemdb onlinedb.

CR:618515

CR Number:   618515 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UX Original Version:   pyxis Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Mar 2010 One-off Provided 29 Mar 2010 Fixed 29 Mar 2010 Fixed 07 Apr 2010 Not a Bug Description DiagQ enhancements under TF 15578. Also, fixes a problem inside OCM where A task is sleeping inside ocm_lock waiting for lock-downgrade(BAST) request to be serviced but BAST is not serviced even though no task is holding ocm_lock;this makes other tasks to block/sleep which in turn cause system hang.

CR:618518

CR Number:   618518 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Windows W2k Original Version:   aries Fixed Version Build Resolution Date Closure Code (If Appropriate) 08 Apr 2010 Fixed Description sp_configure 'enable HA' does not report failure on platforms that do not support HA.

CR:618609

CR Number:   618609 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.0.3 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Optimize NOT IN on NULL columns querys. Workaround Description  1) Re-write query to use not exist. 2) Changte column to use NOT NULL.

CR:618617

CR Number:   618617 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   bharani Fixed Version Build Resolution Date Closure Code (If Appropriate) 04 Oct 2010 Fixed Description (Internal Only) Add support to replicate predicates contained in the "Grant Role" command.

CR:618776

CR Number:   618776 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   all Original Version:   aries Fixed Version Build Resolution Date Closure Code (If Appropriate) 25 Apr 2010 Fixed Description In Sybase Central 6.0 the 'execute' button may become inactive when attempting to execute an external web service through the right-click->'Execute Web Services dialogue box on the 'Web Methods' tab under the 'Web Services' node.

CR:618778

CR Number:   618778 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) 25 Feb 2010 Fixed 23 Jun 2010 One-off Provided Description When compatibility mode is turned on, select assign query which assign a local variable or parameter and use the same local variable or parameter on the qualification side could return wrong results.

CR:618781

CR Number:   618781 Product Name:   Adaptive Server Enterprise Product Component:   Job Scheduler Status:   Closed OS:   all Original Version:   15.0.3 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 28 Feb 2010 Fixed 08 Mar 2010 Fixed Description With the configuration option 'net password encryption reqd' set to 1 or 2, the JSagent fails with "ct_connect() failed", "jsd_MakeConnection() failed", "jsj_AddConxs() failed", "jsj_AddConxs() failed" and "Initialization failed initializing connection pool" messages in jsagent log file.

CR:618799

CR Number:   618799 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.3 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Feb 2010 Duplicate Description New Feature Request ... create a IndexName() funtion that returns the name of an index when object id and index id are provided.

CR:618815

CR Number:   618815 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 Feb 2010 Fixed 02 Mar 2010 Fixed 26 Feb 2010 Fixed Description BCP IN will fail with error 2624 when the target table has one or more encrypted columns and all variable length data in a row is NULL.

CR:618817

CR Number:   618817 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.0.3 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Error 624 may be raised during recovery if the rs_locator value used by the replication agent is stale among other reasons. This is a feature request for a new error message that to be raised for the rs_locator case explicitly pointing out that cause of the error.

CR:618851

CR Number:   618851 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) 22 Feb 2010 Fixed 01 Mar 2010 Fixed 22 Feb 2010 One-off Provided 18 Mar 2010 One-off Provided Description The message "current process infected with 11" in the module 's_free' together with a stack trace which includes the modules 'clean_process' and 'kill_proc' may be reported in the error log when a session executing a query involving session temporary tables was killed by another session and statement cache is enabled in Adaptive Server. Under some circumstamces a 6103 error, "Unable to do cleanup for the killed process; ..." may also be reported after that. Workaround Description  Turn off statement cache OR use command line traceflag 467 -- disables the fix for 493412 OR use command line traceflag 299 -- this will only work if there is already a successfully compiled plan in cache

CR:618859

CR Number:   618859 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) 29 Jun 2010 Fixed 02 Jul 2010 Added to user documentation 03 Nov 2011 Duplicate Description MDA table monCachedObject differentiates user objects as tables or indexes instead of 'user table' only.

CR:618876

CR Number:   618876 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) Description Error 585 is raised when IDENTITY_INSERT is used to insert the result of a SELECT UNION ALL into a table with an identity column. No error is raised with plain UNION.

CR:618881

CR Number:   618881 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) 11 Aug 2011 Fixed Description An infected with 11 involving operator LeHashOp or LeGroupSortedOp may be raised when selecting an aggregate function such as count() from a DISTINCT derived table based on an equijoin between local and proxy tables and the equijoin is on char/varchar type columns. Workaround Description  traceflag 15321 to disable transitive closure fix on char type columns.

CR:618910

CR Number:   618910 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   pyxis Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 Feb 2010 Fixed 22 Feb 2010 One-off Provided 19 Feb 2010 Reservation Made 12 Mar 2010 One-off Provided Description The diagnostic information that is reported for the 707 error has been enhanced. Following a 707 error, a message of the form: (<module name>) Diagnostics for error 707 state 10: <diagnostic info> is reported in the error log together with a stack trace. An additional single line of diagnostics is reported prior to the message and stack trace above, when the 723 trace flag is turned on.

CR:618926

CR Number:   618926 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   Aries CE Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 Mar 2010 Fixed 05 May 2010 Fixed 08 Jun 2010 Presently Not Targeted For Any Future Release Of This Product 04 Oct 2010 One-off Provided Description A connection/isql session may get terminated printing out a stacktrace involving the functions :s_compile(), s_compile_stmt(), PssInit(), getdbsize_in_mb() in that order when the task receives attention when waiting/sleeping after a lock request.

CR:618958

CR Number:   618958 Product Name:   Adaptive Server Enterprise Product Component:   DDLGen Status:   Closed OS:   all Original Version:   15.5 ESD #1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 23 Feb 2010 Fixed Description ddlgen 155 fail with source ASE 12.5.x. Workaround Description  Use ddlgen from 15.0.x

CR:618963

CR Number:   618963 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.3 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16 Mar 2010 Fixed 18 Mar 2010 Fixed 22 Mar 2010 Fixed Description On a multi-engine server, the number of Ct-lib connections per engine may not be evenly distributed among all the engines. The load imbalance is observed using the sybmon command 'engines -1 ectcount'. Workaround Description  None

CR:618975

CR Number:   618975 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) bharani 23 Mar 2010 Fixed Description RAT error message 9265 displays an incorrect database id value.

CR:619016

CR Number:   619016 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.0.3 CE Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 Mar 2010 Fixed Description The message "Starting diagnostics for read failure" together with a stack trace which includes the modules 'db_diskremap', 'db__diskremap_sysusages' and 'pg_fill_supergam' may be reported in the error log when a database dump from a different platform and with a different diskmap is loaded in a ASE cluster server. Workaround Description  Avoid remapping during a cross platform dump to cluster edition by making sure the map of the database that is loaded is the same as the map of the database which was dumped.

CR:619051

CR Number:   619051 Product Name:   ASE Management Product Component:   Monitoring Data Collector Status:   Closed OS:   Generic Original Version:   3.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 31 Oct 2011 Fixed 26 Aug 2011 Added to user documentation Description The Sybase Control Center ASE Monitor reports error 12052 when the Statement Cache screen is opened for an ASE server that does not have the statement cache enabled.

CR:619118

CR Number:   619118 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UX Original Version:   pyxis Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 Mar 2010 Bundled Request 11 Mar 2010 One-off Provided Description The automatic start of Backup Server results in defunct sybmultbuf process after the backup is complete. Workaround Description  Restart Backup Server manually using RUN script and disable 'enable backupserver HA' configuration option.

CR:619134

CR Number:   619134 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   aries Fixed Version Build Resolution Date Closure Code (If Appropriate) 22 Dec 2010 Fixed Description @@rowcount is not 0 after TRANSFER TABLE command failed to import data.

CR:619141

CR Number:   619141 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.3 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 Apr 2010 Consult Complete Description REORG: compact followed by sp_flushstats systabstats.delrowcnt incorrect

CR:619229

CR Number:   619229 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UNIX Original Version:   15.0.3 CE Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Mar 2010 One-off Provided 28 May 2010 Diagnostic Provided Description Rep Agent does not send some commands to Replication Server. Workaround Description  None.

CR:619234

CR Number:   619234 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) Description Feature request to allow success/failure auditing of system stored procedures.

CR:619238

CR Number:   619238 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.3 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 24 May 2010 Fixed 01 Jun 2010 Fixed 01 Jun 2010 Fixed 02 Jun 2010 Fixed 09 Jun 2010 Fixed 14 Jun 2010 Fixed 25 Jun 2010 One-off Provided Description Under certain specific circumstances, calling a user defined function within a cursor that is defined in a second user defined function can result in a stack trace in ASE. Workaround Description  N/A

CR:619240

CR Number:   619240 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.0.3 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description ASE to implement full TOP functionality as views, subquery ....

CR:619259

CR Number:   619259 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.3 CE Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Mar 2010 Presently Not Targeted For Any Future Release Of This Product 12 Mar 2010 Fixed Description When an instance is initializing shared memory which could take a very long time, it is not sending cluster heartbeats to the other cluster members. Workaround Description  Increase the cluster heartbeat interval to a very large value or increase the number of cluster heartbeat retries to a very large value

CR:619267

CR Number:   619267 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.3 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 28 May 2010 Fixed 01 Jun 2010 Fixed Description User Defined Functions may not get called correctly in queries involving outer joins

CR:619324

CR Number:   619324 Product Name:   Adaptive Server Enterprise Product Component:   DDLGen Status:   Closed OS:   all Original Version:   15.0.3 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 22 Feb 2010 Fixed 22 Feb 2010 Fixed Description DDLGen for a table does not generate ddl for indexes which have been created with sorted_data option

CR:619387

CR Number:   619387 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) 22 Feb 2010 Fixed Description Print command in sybmon cannot print double data type correctly.

CR:619396

CR Number:   619396 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UNIX Original Version:   15.0.3 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 03 Mar 2010 Fixed 22 Jun 2010 One-off Provided 09 Jun 2010 Fixed 07 Jun 2010 Presently Not Targeted For Any Future Release Of This Product 18 Jun 2010 Fixed 24 Jun 2010 Fixed Description On the platforms that support dynamic CPU additions, after adding a CPU, ASE engine online fails with error like "kernel ueonline: Not enough CPUs to online engine. Number of CPUs 7. Engine Number 8. Please reset the number of engines at startup parameter."

CR:619397

CR Number:   619397 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 Enhance sysdepends so it can handle cross-database dependency and does not lose dependency information as dependent objects are dropped and rebuilt

CR:619431

CR Number:   619431 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   NA Original Version:   Aries CE Fixed Version Build Resolution Date Closure Code (If Appropriate) 24 Mar 2010 Fixed Description In rare circumstances error 834 (Illegal attempt to clean buffer) may be reported in the errorlog while starting alter table utility on multinode cluster.

CR:619437

CR Number:   619437 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 to provide an option to DBCC LOG to limit output to a particular range of datetime values.

CR:619575

CR Number:   619575 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.3 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 28 May 2010 Presently Not Targeted For Any Future Release Of This Product Description Compatibility mode doesn't update monOpenObjectActivity UsedCount,LastUsedD

CR:619611

CR Number:   619611 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   aries Fixed Version Build Resolution Date Closure Code (If Appropriate) 25 Feb 2010 Fixed 05 Mar 2010 Fixed 11 Mar 2010 One-off Provided Description Under certain circumstance, an error 632 may happen to an instance of a multiple instance cluster, it may lead to subsequent error 1601 and error 8601on the same instance, and bunch of user tasks can't proceed on one or multiple instances of the cluster when the situation occurs.

CR:619707

CR Number:   619707 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) 07 Apr 2010 Fixed 29 Mar 2010 Fixed Description Errors 208 and 267 'Object not found' may be raised incorrectly from a stored procedure if the procedural statement is compiled in the deferred mode.

CR:619756

CR Number:   619756 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 Apr 2010 Fixed 18 Mar 2010 Reservation Made 04 May 2010 Fixed 06 May 2010 Fixed Description Row estimates for a distinct or GROUP BY aggregate operation may not be accurate, which may result in an incorrect row count estimate of 1532 rows. This can occur when there are missing histograms involved on some of the columns or expressions are used for which histograms do not exist. Workaround Description  The 12.5 query plan should be able to be created as the following script below, and the AP dump load with autoparam enabled should be able to load the plan with different parameters as below. (or if just using the AP PLAN clause is possible) set plan dump on /*save to the default group*/ go set literal_autoparam on go select t0.PROD_SEC_ID_I,t0.PROD_SEC_NBR_C,t0.PROD_SEC_CUSIP_C,t0.PROD_GEN_ISSUER_N,t0.PROD_ISSUER_NUMBER, t0.PROD_DESC_1_C,t0.PROD_DESC_2_C,t0.PROD_DESC_3_C,t0.PROD_DESC_4_C,t0.PROD_CURRENCY_C,t0.PROD_FIG_FACTOR_I, t0.PROD_FIG_FLUX_F,t0.PROD_FIG_MULT_I,t0.ROW_LAST_UPD_Z_ADD,t0.ROW_LAST_UPD_Z_UPD,t0.PROD_ENTITY_C,t0.PRI_CURR_C, t0.PROD_PROF_TYPE_ID_I,t0.PROD_FACTORABLE_C,t0.EXPIRED_D,t0.PROD_PRIME_TICKER_C,t0.PRICE_QUOT_CONV_I from PRODUCT t0 where exists (select 1 from FROZEN_POSITION t1 where t0.PROD_SEC_ID_I = t1.PROD_SEC_ID_I and ( t1.OUT_Z = '9999-12-01 23:59:00.000' and t1.FROM_Z < '2009-12-18 18:30:00.000' and t1.THRU_Z >= '2009-12-18 18:30:00.000' ) and ( t1.POS_TYP_C = 1801 and abs(t1.POS_QUANTITY_M) >= 1.0E-6 ) ) and exists (select 1 from PRODUCT_CATEGORY_MAP t2 where t0.PROD_PROF_TYPE_ID_I = t2.PROD_PROF_TYPE_ID_I and t2.PROD_CATEGORY_ID_I in ( 29,44,45,61,68,70) ) plan "( nl_join ( nl_join ( distinct_sorted ( i_scan IDX_FPOS_PROD ( table ( t1 FROZEN_POSITION ) ) ) ) ( i_scan Yan_NC2 ( table ( t0 PRODUCT ) ) ) ) ( i_scan pk_PRODUCT_CATEGORY_MAP ( table ( t2 PRODUCT_CATEGORY_MAP ) ) ) )" go go set plan dump off go sp_copy_all_qplans ap_stdout, ap_stdin go set plan load on go set showplan on go /* the following query had dates changed to 2010, and the showplan shows the AP was loaded */ select t0.PROD_SEC_ID_I,t0.PROD_SEC_NBR_C,t0.PROD_SEC_CUSIP_C,t0.PROD_GEN_ISSUER_N,t0.PROD_ISSUER_NUMBER, t0.PROD_DESC_1_C,t0.PROD_DESC_2_C,t0.PROD_DESC_3_C,t0.PROD_DESC_4_C,t0.PROD_CURRENCY_C,t0.PROD_FIG_FACTOR_I, t0.PROD_FIG_FLUX_F,t0.PROD_FIG_MULT_I,t0.ROW_LAST_UPD_Z_ADD,t0.ROW_LAST_UPD_Z_UPD,t0.PROD_ENTITY_C,t0.PRI_CURR_C, t0.PROD_PROF_TYPE_ID_I,t0.PROD_FACTORABLE_C,t0.EXPIRED_D,t0.PROD_PRIME_TICKER_C,t0.PRICE_QUOT_CONV_I from PRODUCT t0 where exists (select 1 from FROZEN_POSITION t1 where t0.PROD_SEC_ID_I = t1.PROD_SEC_ID_I and ( t1.OUT_Z = '9999-12-01 23:59:00.000' and t1.FROM_Z < '2010-12-18 18:30:00.000' and t1.THRU_Z >= '2010-12-18 18:30:00.000' ) and ( t1.POS_TYP_C = 1801 and abs(t1.POS_QUANTITY_M) >= 1.0E-6 ) ) and exists (select 1 from PRODUCT_CATEGORY_MAP t2 where t0.PROD_PROF_TYPE_ID_I = t2.PROD_PROF_TYPE_ID_I and t2.PROD_CATEGORY_ID_I in ( 29,44,45,61,68,70) ) go

CR:619781

CR Number:   619781 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   Solaris Original Version:   15.0.3 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description sp_helpdevice master incorrectly shows that the master device is opened with dsync 'on' and direct i/o 'off' even if the master device is the file system and the platform supports direct i/o.

CR:619857

CR Number:   619857 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UX Original Version:   aries Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Apr 2010 Fixed 22 Apr 2010 Fixed Description Transfer table import command in hppa platform would throw sig11 if the file provided to the command is corrupt or empty.

CR:619893

CR Number:   619893 Product Name:   Adaptive Server Enterprise Product Component:   sqlupgrade Status:   Closed OS:   all Original Version:   15.5 ESD #1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Mar 2010 Fixed Description sqlupgrade help button on the upgrade status screen fails to show the message.

CR:619916

CR Number:   619916 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.3 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 05 Apr 2010 Fixed 06 Apr 2010 Fixed Description If a query involes a column from a view and the column is defined as an expression with subquery, and this column appears in the select-list and in a conditional expression(or-clause or case statement) in the query's predicate-list, the query might return wrong results.

CR:619932

CR Number:   619932 Product Name:   SySAM Product Component:   FLEXlm Status:   Closed OS:   all Original Version:   11.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Feb 2013 Third Party Problem Description SYSAM lmreread fails due to hostname being truncated at 32 characters.

CR:619938

CR Number:   619938 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   Linux Original Version:   15.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description dbcc checktable returns "An invalid 'data row id' value..." after upgrade

CR:619956

CR Number:   619956 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) Description sp_setreptable and sp_setreplicate without table name, do not list tables with replicate status of never. Workaround Description  Query the table with the table name or decode sysattributes

CR:619965

CR Number:   619965 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 Feb 2010 Fixed 26 Feb 2010 Reservation Made Description if a histogram cell has the specific date "Jan 1 1900 12:00:00:000AM" then it will not be recognized as a dense frequency cell, which means that for this specific date, the range density would be used for an estimation rather than the weight of the frequency cell in the histogram. fix is enabled under optcriteria cr619965 which has been associated with optlevel ase1503esd4 for all optgoals Workaround Description  edit statistics for the datetime column so that "Jan 1 1900 12:00:00:000AM" is represented by a sparse frequency cell i.e. 2 cells with the same value of "Jan 1 1900 12:00:00:000AM" rather than a dense frequency cell of "Dec 31 1899 11:59:59:996PM" followed by "Jan 1 1900 12:00:00:000AM"

CR:620045

CR Number:   620045 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.0.3 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 07 Apr 2010 Fixed 21 May 2010 Presently Not Targeted For Any Future Release Of This Product 09 Apr 2010 Fixed 20 Apr 2010 Fixed 21 Apr 2010 Fixed 06 May 2010 One-off Provided Description Under -T2792, if built-in functions are trying to access a table on which a reorg-rebuild is under way there is a possibility of undetected deadlock between reorg rebuild and the running task. Note that 2792 is a trace flag used to make the concurrent tasks sleep when reorg rebuild/AMC is under way instead of throwing 8233 error.

CR:620108

CR Number:   620108 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) 09 Aug 2010 Fixed Description sp_helpdb will not display information on a database if the suid column value in sysdatabases for that database does not exist in syslogins. Workaround Description  Databases should have owners, update the suid field to the suid of an appropriate owner login. or Modify the code as specified in the cr description to have sp_helpdb display the database info with "NULL" as the owner name.

CR:620146

CR Number:   620146 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.0.3 CE Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Mar 2010 Fixed 11 Mar 2010 One-off Provided Description In a Multi-Node cluster, a node crash and re-join could end up generating duplicate identity values for objects with identity column.

CR:620173

CR Number:   620173 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.3 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 31 May 2010 Presently Not Targeted For Any Future Release Of This Product 21 Sep 2010 Fixed Description Under rare circumstances, due to missing cleanup code that is normally performed when an ASE task disconnects from the COTS JavaVM, stale entries for UDF/ADT objects may be left behind and could be processed mistakenly when the COTS JavaVM migrates to another engine resulting in unpredictable JavaVM processing and sometimes in ASE shutting itself implicitly. Workaround Description  There is no workaround. the problem comes down to faulty code arrangements.

CR:620181

CR Number:   620181 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.5 ESD #1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 Jun 2010 Fixed 30 Jun 2010 One-off Provided 31 Aug 2012 Fixed Description In multi-engine systems, performance degradation might happen due to high spinlock contention on rdesmgr_spin.

CR:620183

CR Number:   620183 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.3 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 09 Mar 2010 Fixed 09 Mar 2010 Reservation Made 16 Mar 2010 One-off Provided 18 Mar 2010 Fixed 19 Mar 2010 Fixed Description DB2 DATE and TIME datatype cannot be mapped to an ASE DATE and TIME datatype against MFC 15. They are mapped to ASE DATETIME datatype instead. A workaround fix is provided to enable the mapping and traceflag 11238 is used to turn on the fix.

CR:620241

CR Number:   620241 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) 03 Mar 2010 Fixed 11 Mar 2010 Fixed 09 Mar 2010 Fixed 11 Mar 2010 Fixed 11 Oct 2011 One-off Provided Description In rare circumnstances, database processes are waiting for a semaphore from the kernel memory pool and can not be killed.

CR:620250

CR Number:   620250 Product Name:   Adaptive Server Generic Docs Product Component:   Transact-SQL Users Guide Status:   Closed OS:   all Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 26 Feb 2010 Added to user documentation Description The formula provided for calculating the precision and scale of the result of a division operation on two numeric datatypes appears to be incorrect. The correct formula for the precision should be max(s1 + p2 + 1, 6) + p1 - s1 + s2 and for scale max( s1 + p2 + 1,6) Workaround Description  N/A

CR:620278

CR Number:   620278 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.3 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 09 Jun 2010 Fixed 09 Jun 2010 Fixed Description SEGV 11 in AnyDataType::_computeBoolResult. Workaround Description  Workaround 1 The problem query is attempting to compare -ve value with an unsigned datatype. Clearly one can never get equality from such a predicate, so it seems to me the SQL could be modified. Workaround 2 Turn off literal autoparam. set literal_autoparam off go

CR:620330

CR Number:   620330 Product Name:   Adaptive Server Enterprise Product Component:   diagserver Status:   Closed OS:   Linux Original Version:   aries Fixed Version Build Resolution Date Closure Code (If Appropriate) 25 May 2010 Added to user documentation Description SySAM standalone server installer included in the ASE 15.5 installation files missing cpuinfo , lmutil and sysam. Workaround Description  Customer can download lmutil and sysam files at http://www.sybase.com/detail?id=1050143 Customer also can run this command to install the SySAM Utilities: ./archives/sysam_util/setup.bin LAX_VM <full path to "java" 6.0 executable>

CR:620382

CR Number:   620382 Product Name:   Adaptive Server Enterprise Product Component:   InstallShield Status:   Closed OS:   Linux Original Version:   15.0.3 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 01 Mar 2010 Fixed Description An ASE installer is aborted when satisfying the following requirements. An installer will be stopped after it selects license type of 1. 1. LANG=ja_JP.utf8 2. setup -console option used. Workaround Description  Please use GUI mode or LANG=c

CR:620470

CR Number:   620470 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   Aries CE Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 Apr 2012 Presently Not Targeted For Any Future Release Of This Product 15 Sep 2010 Fixed Description The message "closetable: table already closed for sdes <value>" together with a stack trace which includes the modules 'closetable' and 'pg__allocate' may be reported in the error log when a DML command has been previously run and hit error 1105.

CR:620503

CR Number:   620503 Product Name:   Adaptive Server Generic Docs Product Component:   System Administration Guide Status:   Closed OS:   all Original Version:   To Be Determined Fixed Version Build Resolution Date Closure Code (If Appropriate) 22 Oct 2010 Added to user documentation Description Doc Enhancement request for discussion of precedence of password policy related settings. In general, login-specific settings override global settings, a login attempt has to pass all the applicable limits to succeed, so the most restrictive limits have precedence.

CR:620504

CR Number:   620504 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX 5.1 Original Version:   aries Fixed Version Build Resolution Date Closure Code (If Appropriate) 10 Mar 2010 Fixed Description Fix the error 871/20/2 when running reorg compact in ASE 15.5

CR:620512

CR Number:   620512 Product Name:   Adaptive Server Enterprise Product Component:   backup server Status:   Closed OS:   HP-UNIX Original Version:   15.0.3 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 24 May 2010 One-off Provided 03 Jun 2010 One-off Provided 21 Jul 2010 Fixed 13 Sep 2010 Fixed 13 Jul 2010 One-off Provided 21 Jul 2010 Reservation Made 10 Aug 2010 One-off Provided Description Backup Server does not print Operating System error when a Network error (status 32) is encountered in srv__io_check.