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

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

CR:670889

CR Number:   670889 Product Name:   XML Model Product Component:   XML Model Status:   Closed OS:   all Original Version:   chambord Fixed Version Build Resolution Date Closure Code (If Appropriate) 08 Dec 2011 Fixed Description Cosmetic issue In a XML model, the Orientation display preference options are misaligned. To reproduce: 1) open a XML model 2) select Tools\Display Preferences 3) Select General setting and General tab Note: for the Orientation section, the Horizontal option appears to centered vertically and the Vertical option appears to be set to 'Bottom'

CR:670907

CR Number:   670907 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) 28 Jun 2011 Fixed 13 Jul 2011 One-off Provided 21 Jul 2011 Fixed 26 Sep 2012 Fixed Description ASE may crash unrecoverably with signal 11 in ct_poll when a connection to a remote server running an SQL query is killed. Workaround Description  Possible workaround is to adjust the 'cis connect timeout' or 'cis connection timeout' values to alleviate any race conditions.

CR:670973

CR Number:   670973 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.5 ESD #4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 24 Jun 2011 Fixed 27 Jul 2011 Fixed 08 Aug 2011 Fixed 09 Aug 2011 Fixed Description When more than one column is encrypted with same key encrypted by user password, even if wrong password is specified for one of the columns during bcp out, no error is given and bcp succeeds.

CR:671049

CR Number:   671049 Product Name:   Adaptive Server Platform_Specific Docs Product Component:   Installation Guide for Linux Status:   Closed OS:   all Original Version:   15.5 ESD #3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 26 Aug 2011 Presently Not Targeted For Any Future Release Of This Product Description sp_sysmon I/Os Delayed by is not reported correct for linux 64 bit platform.

CR:671084

CR Number:   671084 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   aries Fixed Version Build Resolution Date Closure Code (If Appropriate) 28 Nov 2011 Not reproducible with latest version of the product available as of Resolution Date Description Error 644 may be reported on a nonclustered index of an APL table that has a clustered index that allows duplicates, and the row being inserted is a duplicate. Workaround Description  Try to apply trace flag 655.

CR:671096

CR Number:   671096 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.3 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15 Oct 2013 Insufficient info provided Description A query involving a join between proxy tables may receive an infected with 11 with a stacktrace containing the function CtlibRemoteAccess::cursorClose(_cscommand*, CtlibRemoteAccess::CURSOR_STATE, char*, const char*, bool)

CR:671101

CR Number:   671101 Product Name:   XML Model Product Component:   XML Model Status:   Open OS:   all Original Version:   chambord Fixed Version Build Resolution Date Closure Code (If Appropriate) Description For a new XSM, the default code format is Mixed Case; suggest it should be Upper CamelCase, to avoid generating tag names with underscores

CR:671104

CR Number:   671104 Product Name:   XML Model Product Component:   XML Model Status:   Closed OS:   all Original Version:   chambord Fixed Version Build Resolution Date Closure Code (If Appropriate) 07 Jun 2011 Not a Bug Description When adding attributes to elements, the element symbol overlaps nearby symbols. There is noway to correct the diagram except to toggle the Display Preferences\orientation attribute from horizontal to vertical To reproduce: 1) create a new XML model 2) create a new element (element_1) 3) add three new elements to element(element_1) (The three new elements branch off the sequence) 4) add several attributes to element_2 NOTE: element_2 now overlaps the other elements Neither collapsing the sequence, auto-layout, nor redisplay corrects the issue. The only workaround is to change the orientation from horizontal to vertical

CR:671105

CR Number:   671105 Product Name:   XML Model Product Component:   XML Model Status:   Closed OS:   all Original Version:   chambord Fixed Version Build Resolution Date Closure Code (If Appropriate) 23 May 2011 Duplicate Description Parameter substitution in XSM Language menu Open a XML model Click Language menu The menu reads... Generate %s File Reverse Engineer %s File Instead of... Generate Schema Files Reverse Engineer Schema Files

CR:671131

CR Number:   671131 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UX Original Version:   15.7 Drop#3B Prelim Fixed Version Build Resolution Date Closure Code (If Appropriate) 25 May 2011 Fixed Description Under rare circumstances an undetected deadlock may occur between 3 sessions. Session #1 is running DUMP TRAN WITH NO_LOG, already holds the append log semaphore lock and is waiting for an exclusive latch lock on syscolumns page 'P1' to be granted. Session #2 is running DROP TABLE, holds the conflicting with session #1 exclusive latch lock on syscolumns page 'P1' and is waiting for a PLC lock to be granted. Session #3 is running DROP TABLE, holds the conflicting with session #2 PLC lock and is waiting for the append log semaphore lock to be granted, which lock is held by session #1.

CR:671152

CR Number:   671152 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   Solaris Original Version:   15.5 ESD #3 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Both a user-defined threshold and a last chance threshold may not be fired and ASE runs out of log free space with a 1105 error and a 3475 error on a mixed data and log database. Workaround Description  (1) Set "trunc log on chkpt" to the database option if possible. You can not set this db option to master database. (2) Remove user-defined thresholds if possible. (3) Run a dump transaction command with truncate_only manually and periodically.

CR:671228

CR Number:   671228 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 CGA Drop#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 31 May 2011 Presently Not Targeted For Any Future Release Of This Product 27 May 2011 Fixed 01 Jun 2011 Fixed 03 Jun 2011 Fixed Description ASE running on Linux platforms with batch I/O enabled (which is enabled by default) could hit timeslice errors in the module basis_flushbatchio().

CR:671238

CR Number:   671238 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.3 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 10 May 2012 Fixed 10 Feb 2012 DEFER 31 May 2012 Fixed 30 Jan 2013 One-off Provided 16 Apr 2013 Fixed Description The message "current process infected with 11" in the module 'proc_find_subscribable' together with a stack trace which includes the modules 'lt_sqlrep_exec_polic' and 's_mustrecompile' may be reported in the error log when a stored procedure is marked for replication and ASE is checking if the stored procedure needs recompilation.

CR:671337

CR Number:   671337 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.7 Drop#3B RTC Fixed Version Build Resolution Date Closure Code (If Appropriate) 27 May 2011 Fixed Description The error 15700, "Failed to read the virtual page 'n' from the device 'm'", together with "sddone: Invalid argument", can be raised when trying to load an archive database if the archive database devices have been initialized with any of the options DSYNC or DIRECTIO set to TRUE, explicitly or by default configuration. Workaround Description  Boot the server with trace flag -T1623

CR:671370

CR Number:   671370 Product Name:   Adaptive Server Generic Docs Product Component:   Transact-SQL Users Guide Status:   Closed OS:   all Original Version:   15.5 ESD #5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 Mar 2014 Added to user documentation Description Correct Documentation for exp_row_size and it's maxlen and minlen value.

CR:671405

CR Number:   671405 Product Name:   ASE Management Product Component:   Web Console Status:   Closed OS:   Generic Original Version:   3.1.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 08 Jun 2011 Fixed Description Authentication error message does not clearly specify that something might be wrong with the host name or port number of the registered ASE resource. Workaround Description  Right mouse-click on the resource and bring up Properties. Left mouse on connection. Change the appropriate connection property and press apply. Then go back to the perspective and try and authenticate the server again.

CR:671418

CR Number:   671418 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.7 Drop#3B Fixed Version Build Resolution Date Closure Code (If Appropriate) 09 Jan 2012 Bundled Request Description Adaptive Server running in threaded mode with a single client that is doing heavy i/o workload can incur response time performnce loss. Workaround Description  Adaptive Server performs best when it runs on as few physical processors as possible. If your host has four processors, but Adaptive Server only requires one processor of power (including all of its cores), consider binding the dataserver process to that processor. Similarly, if Adaptive Server needs two processors of power, consider binding dataserver to two specific processors rather than allowing the operating system to schedule it between all four processors. You can do this using the numactl command, the taskset command, or the cgroups (control groups) feature. For example, to start Adaptive Server such that it will only run on processors 0 and 1, numactl can be used: numactl --cpunodebind=0,1 startserver -fRUN_server

CR:671436

CR Number:   671436 Product Name:   Adaptive Server Enterprise Product Component:   Job Scheduler Status:   Closed OS:   all Original Version:   15.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 27 Nov 2011 Fixed 11 Dec 2011 Fixed Description Job Scheduler runs a job multiple times over a minute under some situations. Workaround Description  Use repeats=1d exec sybmgmtdb..sp_sjobcreate 'sname=SAP_SCHEDULE_ATM_W3', 'sdesc=SAP ATM Window 3,days=Thursday,repeats=1d,startdate=2011-05-19,starttime=11:30'

CR:671437

CR Number:   671437 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.5 ESD #5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 Jun 2011 Fixed 03 Jun 2011 Reservation Made 29 Jun 2011 Fixed Description Parallel query plans are not chosen over serial query plans when using a large number of engines due to over optimistic costing of serial query plans.

CR:671439

CR Number:   671439 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.5 ESD #3 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Feature request to implement an option to stop sp_helpsort consuming transaction log on master. Workaround Description  Run dump tran master with truncate_only after sp_helpsort. Or setup threshold. Or comment out the line calling sortkey(null, "all") in sp_helpsort if acceptable.

CR:671440

CR Number:   671440 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   auriga Fixed Version Build Resolution Date Closure Code (If Appropriate) 15 Jun 2011 Fixed 07 Jun 2011 Fixed 16 Jun 2011 Fixed 01 Jul 2011 One-off Provided 13 Sep 2012 Fixed Description Under some rare circumstances, ONLINE DATABASE or LOAD TRAN command may fail with a stack trace showing module xls_pre_alloc_numclrs and plc__flush. This may happen after loading a transaction dump including log records written by a CREATE INDEX command run for a DOL table. Workaround Description  1. Avoid that "dump tran" captures placement index creation i.e run "dump database" each time a placement index is created. or 2. During the load sequence, disconnect and reconnect to ASE between "load database", each "load tran" and "online" commands. (This workaround may or may not apply depending on how many 'create placement index' commands are captured within a single transaction dump : it won't apply if the same transaction dump contains 2 or more 'create placement index' in a row, each of those causing btree splits)

CR:671536

CR Number:   671536 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.0.2 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 06 Jun 2011 Fixed 30 Jun 2011 One-off Provided 20 Sep 2012 Fixed Description In certain circumstances, a query that contains an OR clause with multiple joins may generate a sub-optimal plan, with respect to result accurracy, when executed with the optimizer level of ase_default. Workaround Description  When running the query under optimiser level ase_default, the option use_mixed_dt_sarg_under_specialor should be turned off.

CR:671569

CR Number:   671569 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 Be able to only send sql statements for a table while other tables do not replicate sql statements. Workaround Description  currently none because although you can set up sql statement replication by table (sp_setrepdefmode), one has to exceed the threshold. Therefore a statement has to affect a minimum of 2 statements for the sql statement to be run.

CR:671592

CR Number:   671592 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) 06 Jul 2011 Fixed 11 Jul 2011 One-off Provided 28 Jul 2011 Fixed 20 Sep 2012 Fixed Description Lots of concurrent logins may result in error 290024 and stacktraces during ASE authentication.

CR:671598

CR Number:   671598 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.5 ESD #2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 31 May 2011 Fixed 31 May 2011 Fixed 01 Jun 2011 Fixed Description A 15760 error, "Invalid dump header when loading the database with ID '<value>'" may be reported when attempting to load a valid database dump into an archive database.

CR:671752

CR Number:   671752 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX Original Version:   15.5 ESD #3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15 Jun 2011 Fixed 27 Jun 2011 Fixed 27 Jun 2011 Fixed Description Truncation od text at the Data Cache Manangement section causes spinlock contention information not to be reported by sp_sysmon. Workaround Description  Use the script of 'sp_sysmon_dcache_dtl' from ASE 15.5 ESD#2

CR:671764

CR Number:   671764 Product Name:   ASE Management Product Component:   Web Console Status:   Closed OS:   Windows XP Pro Original Version:   3.2.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 03 Jun 2011 Fixed Description This problem happens on Monitoring view of Cluster Edition ASE in the Database view. When the database item on the top table is changed, the label "Selected database: <name>" in the bottom tab does not change. This resolution fixes the problem.

CR:671788

CR Number:   671788 Product Name:   Adaptive Server Enterprise Product Component:   DBISQL Status:   Closed OS:   Windows XP Original Version:   15.5 ESD #3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.7 ESD#1 14 Nov 2011 Bundled Request Description When running dbisql from pcclient distribution, trying to use the import function, it is reported that the JDBC driver is missing. Workaround Description  modify the dbisql.ini file so that: ADDITIONAL_CLASSPATH=<directory>\jconn3.jar Note: jconn3.jar might not be in some distributions, get it from jConnect-6_0 directory in another distribution. Be sure to look for a copy of dbisql.exe that might be still running on the PC, even after you have exited the program. Kill it from the taskmgr and then attempt the workaround.

CR:671950

CR Number:   671950 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX Original Version:   15.5 ESD #3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 23 Aug 2011 Fixed 23 Nov 2011 Fixed Description DDL generated by sp_helptext using the 'ddlgen' option may result in an error. This occurs due to the expansion of "*" to the individual column names.

CR:671953

CR Number:   671953 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   Linux Original Version:   15.0.3 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description slow bcp performance on linux platforms when using DIRECTIO for devices

CR:671997

CR Number:   671997 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX Original Version:   15.0.3 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 Jul 2011 Not a Bug 16 Aug 2011 Fixed 15 Nov 2012 Presently Not Targeted For Any Future Release Of This Product Description On AIX, memory leak may happen when remote server option "net password encryption" is turned on.

CR:672040

CR Number:   672040 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   auriga Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Aug 2011 Fixed Description In rare circumstances, 2510 error, Key mismatch between index page and data page, is returned when dbcc checktable is run for a table with a replication index.

CR:672046

CR Number:   672046 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   auriga Fixed Version Build Resolution Date Closure Code (If Appropriate) 27 Jul 2011 Fixed Description For the job having output with large column length, the JS agent may fail to execute job with following errors in JSAGENT log ( With -T3641): 00:1094719808:46912511093344:2011/06/28 07:33:13.37 worker string provided is too long to add to buffer provided 00:1094719808:46912511093344:2011/06/28 07:33:13.37 worker jsj__AddToBuffer() failed

CR:672144

CR Number:   672144 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.5 ESD #4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Jun 2011 Fixed Description A 2540 error may be reported by DBCC CHECKALLOC following instance failover recovery when a REORG REBUILD (index), CREATE INDEX, DROP TABLE or TRUNCATE TABLE command had completed on the instance just prior to its failure. Workaround Description  N/A

CR:672181

CR Number:   672181 Product Name:   Adaptive Server Enterprise Product Component:   backup server Status:   Closed OS:   Microsoft Windows Original Version:   15.5 ESD #3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 06 Jul 2011 Fixed 12 Jun 2011 Fixed Description Backup Server: On 64-bits Windows platforms, dumps to existing files do not reset the file size when the dump size is less. Workaround Description  Remove larger files before running dump.

CR:672196

CR Number:   672196 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.5 ESD #3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 Aug 2011 Fixed Description MERGE UNION DISTINCT plan could return duplicate rows incorrectly when the union view/derived_table is participating in an equijoin join with another table and there is also a constant sarg (col=<const>) on the other table's equijoin column. Workaround Description  set merge_union_distinct off

CR:672255

CR Number:   672255 Product Name:   Adaptive Server Enterprise Product Component:   MDA/Monitoring Tables Status:   Closed OS:   all Original Version:   15.5 ESD #3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 10 Sep 2012 Fixed 27 Sep 2012 Fixed 08 Oct 2012 Fixed Description In some circumstance, the CPU usage of ASE might increase to near 100% after turning on the plan text pipe active option.

CR:672395

CR Number:   672395 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UNIX Original Version:   15.5 ESD #3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 26 Jan 2012 Insufficient priority to fix Description 143360 bytes only 140K does not appear to be a large enough stack. Just about all customers will have to increase this with sp_configure or experience stack overflow errors. Workaround Description  Increase stack size. sp_configure "stack size", n

CR:672446

CR Number:   672446 Product Name:   Adaptive Server Enterprise Product Component:   syconfig Status:   Closed OS:   Microsoft Windows Original Version:   15.7 Drop#3B Prelim Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Jun 2011 Fixed 26 Aug 2011 One-off Provided 28 Sep 2011 One-off Provided 25 Oct 2011 One-off Provided 02 Nov 2012 Fixed Description After entered the ASE login/password in the login dialog to configure the existing ASE, syconfig crashed.

CR:672597

CR Number:   672597 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX 5.1 Original Version:   15.0.3 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 25 Apr 2012 Not reproducible with latest version of the product available as of Resolution Date Description In rare circumstances, the error 614, Severity: 21, State: 7 might raise when executing a stored procedure and UPDATE a temp table.

CR:672606

CR Number:   672606 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 Drop#3A Fixed Version Build Resolution Date Closure Code (If Appropriate) 26 Apr 2013 Bundled Request Description In some cases the output from the sp_opt_querystats stored procedure would be formatted incorrectly due to lines being broken in the middle of words or due to missing letters or characters.

CR:672733

CR Number:   672733 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.5 ESD #2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 29 Mar 2012 Presently Not Targeted For Any Future Release Of This Product 29 Mar 2012 Fixed 30 Jun 2013 Fixed 18 Jul 2013 One-off Provided 18 Jul 2013 One-off Provided Description A 820 error may be raised when executing BCP-IN with all INSERTSs that causes duplicate key errors during aggressive HOUSEKEEPER garbage collection. Workaround Description  Don't use 'enable housekeeper GC' = 4

CR:672829

CR Number:   672829 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) 15 Jul 2011 Fixed 08 Jul 2011 Consult Complete 20 Jul 2011 Fixed 27 Jul 2011 Fixed 12 Oct 2011 One-off Provided 16 Nov 2011 One-off Provided 18 Sep 2012 Fixed Description There can be high spinlock contention on the ASE network memory pool spinlock. Workaround Description  Whenever the customer is not interested by DDL replication, the session can run "set proxy" cmd, which cmd will bypass session password decryption.

CR:673130

CR Number:   673130 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.5 ESD #3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16 Dec 2011 Workaround Description Sub optimal plan with ase_current related to view and more and 6 tables. Workaround Description  set cr606288 off updating statistics, with a reduced sample set, seems to work.

CR:673156

CR Number:   673156 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 Drop#3B Prelim Fixed Version Build Resolution Date Closure Code (If Appropriate) 24 Jun 2011 Fixed Description Missing brackets for bracketed identifier in abstract plan generation.

CR:673169

CR Number:   673169 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Oct 2011 Presently Not Targeted For Any Future Release Of This Product 14 Oct 2011 Fixed 17 Oct 2011 Fixed 18 Oct 2011 Fixed Description Msg 5893 prints wrong values while trying to increase the number of user connections.

CR:673179

CR Number:   673179 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 Jul 2011 Fixed Description A user defined function or a stored procedure that calls the radians() function with numeric parameter may start returning NULL for all executions once it has been called once in a way that passed NULL to the radians() function.

CR:673339

CR Number:   673339 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) 28 Mar 2012 Bundled Request Description In rare circumstances a 3327 error, "During redo, the page timestamp check found page <pageno> needs redo when the log record is before the first log record in phase 1 that needs redo...", may be reported when loading a database dump that was dumped on a relaxed-durability database (RDDB). Workaround Description  Load the database dump using the 3495 trace flag.

CR:673377

CR Number:   673377 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   aries Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Jun 2011 DEFER Description Feature request to allow login triggers to set the sessions default transaction isolation level.

CR:673379

CR Number:   673379 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   Solaris Original Version:   15.0.3 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Jun 2011 Fixed Description Under some rare circumstances, SELECT INOT on UNION view may fail with error 225, "Cannot run query--referenced object (name NAME NOT RECOVERABLE) dropped during query optimization". Workaround Description  The customer can try to break the original query into two queries: -- set 'select into' for a database sp_dboption db_name,"select into", true go use db_name go create table #tt1 (a1 varchar(30)) go select A.cusip AS T_cusip into existing table #tt1 FROM AbsCmoDb..Deal_new D join AbsCmoDb..Tranche_new T on (D.dealId = T.dealId ) left outer join AgencyCmoDb..AlternateCusips_v_gk A on (D.dealName = A.dealName and T.trancheName = A.trancheName) where A.cusip = '464266AE5' go

CR:673426

CR Number:   673426 Product Name:   Adaptive Server Enterprise Product Component:   sybmigrate Status:   Open OS:   all Original Version:   15.5 ESD #3 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description sybmigrate raises error about non existent index when one table has a text/image column Workaround Description  1) rename source table to have a short name. sp_rename AuditLegalEntityAdditionalData,AuditL 2) ignore error, your table, indexes and data are migrated anyways.

CR:673434

CR Number:   673434 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.5 ESD #3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 27 Apr 2012 Consult Complete Description Sub optimal plan with ase_current related to 631416. Workaround Description  dbcc traceon(328) set cr631416 off

CR:673487

CR Number:   673487 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.5 ESD #4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Jun 2011 Fixed 29 Jun 2011 Fixed 26 Aug 2011 One-off Provided Description In limited cases, parallel GROUPBY queries that use 2-phase grouping strategies and have two or more XCHG operators beneath the 2-phase grouping operator may return duplicate groups with partial aggregate results. Workaround Description  Set tcf 15320 to enable N-to-1 order-preserving xchgs at the risk of livelock scenarios in two-level xchg/group2psorted strategies.

CR:673494

CR Number:   673494 Product Name:   Adaptive Server Enterprise Product Component:   Historical Server Status:   Closed OS:   Solaris Original Version:   15.5 ESD #3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 21 Jun 2011 Fixed Description Historical Server will hang if one attempts a recording session and the monitor server name doesn't start with a letter or this name does't exist in the interface file. Workaround Description  none - check that the entries are valid and the monitor server is up.

CR:673625

CR Number:   673625 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.3 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 22 Jul 2011 Fixed 22 Jul 2011 Reservation Made 22 Jul 2011 Fixed 28 Nov 2011 One-off Provided Description Sub optimal plan with INSERT and/or SELECT INTO using an ORDER BY occurring when optcriteria avoid_bmo_sorts is on Workaround Description  use abstract plan

CR:673638

CR Number:   673638 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.5 ESD #3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 28 Jun 2011 Not a Bug Description Allow DISK INIT to avoid clearing all pages on a raw device

CR:673656

CR Number:   673656 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.5 ESD #3 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Distinguishedname lookups for LDAP cannot exceed 255 characters. Trying to set the dn_lookup_url for primary or secondary to larger values are not possible

CR:673663

CR Number:   673663 Product Name:   Adaptive Server Generic Docs Product Component:   Utility Guide Status:   Open OS:   all Original Version:   15.5 ESD #3 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Bcp documentation leads one to believe that "fast" bcp is a better performer than "slow" bcp in all cases. We need more comprehensive information to help select the best options for the customer.

CR:673764

CR Number:   673764 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 Control GA Fixed Version Build Resolution Date Closure Code (If Appropriate) 16 Aug 2011 Fixed Description While 'lob compression' is enable, BCP and SELECT INTO operations will reserve more pages than the original table, which may cause regression in LOB reserve space.

CR:673792

CR Number:   673792 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   Linux Original Version:   15.5 ESD #3 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Improve disk diagnostic for OS and Batch IO delays for linux platform.

CR:673834

CR Number:   673834 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.5 ESD #3 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description ASE/CIS: Dropping a 'proxy_table' when the remote server is not in sysservers unnecessarily causes error: Msg 7218, Site '<remote_server' not found in sysservers. Workaround Description  Temporarily add the 'proxy_server' while dropping orphaned proxy tables.

CR:673857

CR Number:   673857 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 Drop#3B Prelim Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Jul 2011 Fixed 09 Aug 2011 Fixed Description Set SYBASE_TS_MODE=GLOBAL as the default behaviour of ASE for enabling diagnostic tool access to ASE by default.

CR:673971

CR Number:   673971 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16 Sep 2011 Fixed 21 Sep 2011 Fixed Description New monitor counters are added to the monEngine, monOpenObjectActivity and monOpenPartitionActivity MDA tables.

CR:674006

CR Number:   674006 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.5 ESD #1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 24 Jun 2011 Not a Bug Description Under certain circumstances, two competing SQL queries that read and update a datarows locking table may interfere with each other leading to an unexpected set of data being returned that may not be repeatable when the update has completed. Workaround Description  Run at a more restricted isolation level than the default isolation level

CR:674064

CR Number:   674064 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.5 ESD #3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 21 Jun 2011 Fixed Description ALTER TABLE ADD PARTITION on a Data-only Locked table followed by a CREATE CLUSTERED INDEX with sorted_data option and some DMLs may result in a 1581 error, "Create index was aborted because pages in the data only locked table are not linked." Workaround Description  Remove status 512 from sysindexes.status. Then issue dbcc cacheremove() for the user object or reboot the database or the dataserver.

CR:674110

CR Number:   674110 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   aries Fixed Version Build Resolution Date Closure Code (If Appropriate) Description DBCC checkcatalog reports errors after a view is created based on the xmltable() function. The usertype field in syscolumns is not being set correctly.

CR:674188

CR Number:   674188 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) 16 Jun 2011 Duplicate Description Signal 11 in plc__flush during transaction dump load

CR:674199

CR Number:   674199 Product Name:   Adaptive Server Generic Docs Product Component:   Adaptive Server New Features Guide Status:   Closed OS:   all Original Version:   15.5 ESD #4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 28 Jun 2011 Added to user documentation Description Linux Huge Page Support - platforms restrictions incorrect

CR:674225

CR Number:   674225 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) 25 Apr 2012 EOL'd version. Not to be Fixed. Description EBF 17426 one-off generate wrong stacktrace. Workaround Description  Generate nm output map and map to the correct function. you have a nm here: \\ecss\ts-cases\11674000s\11674902\nm_dataserver.ebf17426_gualala.txt

CR:674235

CR Number:   674235 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX Original Version:   15.5 ESD #3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Jun 2011 Fixed 27 Jun 2011 Fixed Description A 8213 error, "Failed to acquire address lock on object <value>" may be reported in the error log preceded by a stack trace which includes the modules 'des_idtnewval' and 'des__errhdl'. The stack trace information should not be reported.

CR:674251

CR Number:   674251 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.5 ESD #3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 01 Aug 2011 Fixed 01 Aug 2011 Fixed 26 Aug 2011 One-off Provided Description A roundhash N to roundrobin 1 NLJ strategy may return too few rows if compile-time thread adjustment is done. Typically, compile-time thread adjustment might occur if "max parallel degree" is not configured at least one (or more) higher than "max scan parallel degree". Workaround Description  o Increase the "max parallel degree" to be at least one greater than "max scan parallel degree". Although, you may want to increase this even higher. o Turn off traceflags 15331, 16970.

CR:674278

CR Number:   674278 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.5 ESD #5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Jun 2011 Fixed 22 Jun 2011 Fixed Description In limited scenarios, right nested outer joins optimized in parallel mode could generate a SEGV. This would occur if the outer stream of the right nested OJ had replicated partitioning. The stack would contain a calls to OptDeepPDTransform() and eqcGenNlJoinPop(). Workaround Description  Turn off parallel optimization.

CR:674415

CR Number:   674415 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 Drop#3B RTC Fixed Version Build Resolution Date Closure Code (If Appropriate) 28 Jun 2011 Fixed 28 Jun 2011 Fixed 05 Jul 2011 Fixed Description ASE crashes with access violation exception in either spinobtain or uboalloc_from_engine

CR:674505

CR Number:   674505 Product Name:   Sybase ETL Product Component:   other Status:   Open OS:   Unknown Original Version:   4.9 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Document that changing directory for logfiles (user data) can be done in userdata.conf

CR:674535

CR Number:   674535 Product Name:   Adaptive Server Enterprise Product Component:   DBISQL Status:   Closed OS:   AIX Original Version:   15.5 ESD #3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 29 Apr 2013 Fixed Description Products: ASE 15.5 ESD#3 SQL Advantange 12.5.3 EBF 12338 DBISQL version 11.01, build 2430 Problem Description: Customer reports that DBISQL does not report as much detailed message compared with SQL Advantage. Since SQL Advantage is deprecated customer is requesting FR to be implemented:

CR:674587

CR Number:   674587 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.5 ESD #3 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description When using CE and backupserver are configured ROUNDROBIN, only local instance can start the backupserver automatically. Workaround Description  Start backup server on the remote instance.

CR:674601

CR Number:   674601 Product Name:   Adaptive Server Enterprise Product Component:   InstallShield Status:   Closed OS:   Linux Original Version:   15.5 ESD #3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 22 Jun 2011 Third Party Problem Description installshield hangs forever on /usr/bin/which command in tcsh+ Workaround Description  Do not install in tcsh+

CR:674607

CR Number:   674607 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.5 ESD #3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Aug 2011 Fixed 08 Aug 2011 Reservation Made 16 Aug 2011 Fixed 11 Aug 2011 Fixed 10 Aug 2011 Reservation Made 16 Aug 2011 Fixed Description The threads required to run a parallel query may be under calculated. The problem occurs in plans that contain store_index or N-to-1 Nlj strategies. This can lead to the selection of plans that require more threads than the system/query was configured for. This fix is enabled with optcriteria cr647607.

CR:674622

CR Number:   674622 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.5 ESD #2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 06 Jul 2011 Fixed Description A query with a LIKE clause using a long LIKE term and having escape characters may return incorrect results.

CR:674627

CR Number:   674627 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.5 ESD #3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16 Apr 2012 Fixed 18 Jan 2013 One-off Provided 18 Sep 2012 Fixed 02 Oct 2012 Fixed Description When a table is being replicated to a table that includes an additional IDENTITY, an error "AOP not found in getAopt" is raised. Workaround Description  Turn off SQL Statement replication: sp_setrepdbmode <database>,'UDIS','off' go sp_stop_rep_agent <database> go sp_start_rep_agent <database> go

CR:674632

CR Number:   674632 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 04 Mar 2013 Consult Complete 30 Oct 2012 Reservation Made 30 Oct 2012 Fixed 31 Oct 2012 Fixed Description Enhance index scan perforamce on little-endian platforms if the index includes large mount of duplicated keys. Workaround Description  Make index unique, perhaps by including an identity column as an index key. (update 11/09/11, JPMC modified their high duplicate nonclustered indexes via adding a existing unique value column id_tran to the indexes to make them become unique index)

CR:674645

CR Number:   674645 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 Drop#3B RTC Fixed Version Build Resolution Date Closure Code (If Appropriate) 31 Aug 2011 Fixed 01 Dec 2011 Fixed 02 Dec 2011 Fixed Description If a database has LOB compressed tables which stores compressed XML doc, DBCC CHECKDB may report 15960 error message for LOB compression issues.

CR:674764

CR Number:   674764 Product Name:   Adaptive Server Enterprise Product Component:   backup server Status:   Closed OS:   Solaris Original Version:   15.5 ESD #3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 24 Oct 2011 Not reproducible with latest version of the product available as of Resolution Date Description If a spid in ASE which is dumping a database is killed, it can leave the sybmulbuf processes in a hung state. The "dump to" device is unusable until the backupserver is recycled.

CR:674767

CR Number:   674767 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX Original Version:   15.5 ESD #2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 08 Jul 2011 Workaround 19 Jul 2011 Fixed 12 Jul 2011 Reservation Made 14 Jul 2011 Fixed 27 Jul 2011 Fixed Description Add new ASE configuration option 'enable console logging' to control console logging, with DEFAULT value of 0 to disable console logging after server boot.

CR:674877

CR Number:   674877 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.5 ESD #3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 Aug 2011 Fixed 25 Jun 2012 Fixed Description Performance issue on SELECT INTO from encrypted tables for non-privileged user.

CR:674890

CR Number:   674890 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 Drop#3B Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Feb 2012 Fixed 05 Apr 2012 Fixed Description A 2601 error, "Attempt to insert duplicate key row in object ...", may be raised when there are two sessions running the same MERGE statement concurrently against a table with unique index.

CR:674926

CR Number:   674926 Product Name:   Adaptive Server Enterprise Product Component:   Q Application Engine Status:   Open OS:   AIX Original Version:   12.5.4 ESD#10 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description RTDS: CPU associated with the Q engine always report usr+sys=100% by nmon on AIX only.

CR:675179

CR Number:   675179 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Jul 2011 Fixed 06 Jul 2011 Reservation Made 12 Jul 2011 Fixed 13 Jul 2011 Fixed Description Possible incorrect index selection when using OR predicates with equalities referencing multiple attributes of an index. For example, (a = 5 and b = 6) OR (a = 15 or b = 16) when an index exists on (a,b) could be incorrect (notice the multiple attributes, the issue does not exist for IN lists). The change is enabled thru optcriteria cr675179

CR:675292

CR Number:   675292 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 30 Nov 2011 Fixed 02 Dec 2011 Fixed 21 Dec 2011 Fixed 03 Jul 2012 Reservation Made Description Undo of inserts into data-only locked tables that have an index, either by transaction rollback or by database recovery, is slow due to poor prefetch of affected index pages.

CR:675504

CR Number:   675504 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.5 ESD #2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 10 Oct 2011 Fixed 28 Dec 2011 Fixed Description A private install is always increasing the version of the .cfg file on each cluster reboot even when there are NO changes to the configuration. The cluster in question is using a 4K page size and the problem occurs if a cache pool of 32K is configured. Workaround Description  None except : (1) live with it restarting each instance two times or (2) don't use a 32K bufferpool if a 4k pagesize

CR:675563

CR Number:   675563 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.7 Drop#3B Prelim Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Jul 2011 Fixed Description sp_configure/sp_helpconfig report 0 in Memory Used column for config option "heap memory per user"

CR:675594

CR Number:   675594 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 2013 Duplicate Description A 8203 error, "Expected to find the descriptor for object <negative id> in database 2 in DROP state." together with a stack trace which includes the modules 'sqt_free' and 'des__markdestroy' may be reported in the error log when a session is trying to release a dynamic SQL statement (previously prepared) and concurrently another session is trying to access the same prepared statement, for example using the OBJECT_NAME() builtin with the id used by the internal procedure created for the prepared statement.

CR:675622

CR Number:   675622 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.5 ESD #3 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description A new feature request for an option to fully allocate the tempdb devices at startup.

CR:675791

CR Number:   675791 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 Drop#3B RTC Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Jul 2012 Presently Not Targeted For Any Future Release Of This Product 19 Feb 2013 Fixed Description Enhance sp_rename stored procedure to rename data and index partitions.

CR:675990

CR Number:   675990 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX 5.1 Original Version:   15.0.3 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Oct 2011 One-off Provided 14 Jul 2011 Fixed 22 Jul 2011 Fixed 25 Jun 2012 Fixed Description After cross-platform dump and load of a database containing a view defined on a base table with an encrypted column and a decrypt default, the decrypt default information may be lost leading to a 3762 error: "The decrypt_default for column id 27 was not found in the system catalogs."

CR:675995

CR Number:   675995 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.5 ESD #3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 Nov 2011 Deferred 12 Mar 2012 Fixed 08 Mar 2012 Reservation Made Description Enabling replication in a database can reduce the transaction throughput and can cause a high CPU usage. Workaround Description  Refer to the workaround possibility for CR 672829.

CR:675998

CR Number:   675998 Product Name:   Adaptive Server Enterprise Product Component:   Job Scheduler Status:   Open OS:   Linux Original Version:   15.5 ESD #3 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description JS doesn't print error message numbers to the JS log, only the message text

CR:676013

CR Number:   676013 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 Drop#3B RTC Fixed Version Build Resolution Date Closure Code (If Appropriate) 15 Dec 2011 Fixed Description The MDS table monSysLoad may contain NaN,Infinity values for some statistics Workaround Description  Get the char value for the Infinity\NaN and use a conditional check to populate with null. For example:- insert into table (columns) select case when convert(varchar (30),Max_1min ) = 'inf.0' then null else Max_1min end ,case when convert (varchar(30),Avg_1min) = '-nan.0' then null else Avg_1min end from monSysLoad

CR:676122

CR Number:   676122 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 03 Dec 2012 Bundled Request Description ASE does not respond and appears to hang when invalid packets are sent to it.

CR:676148

CR Number:   676148 Product Name:   Adaptive Server Enterprise Product Component:   Pluggable_JVM Status:   Closed OS:   Solaris Original Version:   15.5 ESD #3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Oct 2011 Presently Not Targeted For Any Future Release Of This Product 12 Sep 2011 One-off Provided 03 Nov 2011 One-off Provided 17 Dec 2011 Fixed 02 Oct 2012 Fixed 18 Feb 2013 Presently Not Targeted For Any Future Release Of This Product Description The ASE PCI layer responsible for the execution handshake of ADT and UDF Java operations with the integrated COTS JavaVM is enhanced to achieve better performance.