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

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

CR:428360

CR Number:   428360 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Apr 2006 Fixed 26 Apr 2006 Duplicate 04 May 2006 Fixed Description Normalization failed to remove NOT nodes for a query that projects a built-in function with a subquery as the argument.

CR:428402

CR Number:   428402 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 Oct 2006 Fixed 20 Oct 2006 Fixed 31 Jan 2007 Fixed Description Support statement cache with singleton insert statements. To use the feature, please turn on both 'statement cache' and 'enable literal autoparam' configurations.

CR:428433

CR Number:   428433 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   12.5.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Apr 2006 Fixed 02 May 2006 Fixed Description In rare circumstances on 64-bit Linux AMD, Linux Itanium and Sun Solaris Opertron, the message "Arithmetic overflow occurred" may be erroneously reported when using 'Approximate Numeric Datatypes'.

CR:428438

CR Number:   428438 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   all Original Version:   Galaxy Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 Apr 2006 Fixed Description Previously a server discovery filter for finding servers with port number less than a number didn't work. This has been corrected.

CR:428442

CR Number:   428442 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) 02 Jun 2006 Duplicate Description Native bcp allows invalid time into ASE, which is then picked up by Rep Agent. Workaround Description  Bcp out the table in -c and bcp back in the table with -c. The invalid time will be corrected.

CR:428443

CR Number:   428443 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   Microsoft Windows NT Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 06 Jun 2006 Fixed Description Users without the js_admin_role will see an error and not be able to open the Scheduled Jobs, Jobs, or Schedules folder if the Show All Users menu item is selected from the corresponding menu.

CR:428445

CR Number:   428445 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Apr 2006 Fixed Description An assertion failure and stack trace could be produced when: - the query is unconnected, in that not all FROM clause tables are connected with eachother through join clauses; - a subset of the FROM clause tables form a STAR query, in that there is one table that is equi-joined with each of the other ones; - another subset of the FROM clause tables contains at least 2 tables, that join with eachother but don't join with tables in the STAR subset.

CR:428477

CR Number:   428477 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.0.1 19 Apr 2006 Fixed 21 Apr 2006 Fixed 28 Apr 2006 Fixed Description When enabled, set index_union limits the scan of a table with an or clause.Index unions (also known as an or strategy) are used for queries that contain or clauses. For example: select * from titleauthor where au_id ="409-56-7008" or title_id ="PC8888" If you have enabled index_union, this example uses an index on au_id to find the row IDs (RIDs) of all titleauthor tuples with au_id =409-56-7008", and uses an index on title_id to find the RIDs of all titleauthor tuples with title_id =PC8888". Adaptive Server then unions all RIDs (to eliminate duplicates). The resulting RIDs are joined with a RidJoin to access the data tuples If index_union is disabled, Adaptive Server does not use an index union strategy in a query to limit the table scan. Instead it uses other access paths on the table (in the example above, it would use a table scan for table titleauthor), and applies the or clause as a filter in the scan operator.

CR:428587

CR Number:   428587 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 28 Apr 2006 Fixed Description 695 error maybe given when a load of a database has been aborted and another database is being dropped during cross platform dump and load.

CR:428591

CR Number:   428591 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 Oct 2006 Fixed 25 Oct 2006 One-off Provided 15 Aug 2007 Fixed 20 Dec 2007 Fixed Description Under rare circumstances the "AUDIT PROCESS" system task and a user session that is in the process of auditing may block each other without ASE being able to solve this blocking situation.

CR:428650

CR Number:   428650 Product Name:   Adaptive Server Enterprise Product Component:   Job Scheduler Status:   Closed OS:   all Original Version:   15.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 May 2006 Fixed 04 May 2006 Fixed Description When creating a Job Scheduler schedule from the command-line utilities, the user may receive an error stating that the startdate is later than the enddate when the schedule enddate is specified but the startdate is not specified. Workaround Description  Always specify the schedule startdate when creating a schedule.

CR:428692

CR Number:   428692 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 05 May 2006 Fixed Description ASE internal clock is not updated before the recovery processing is completed for all databases.

CR:428694

CR Number:   428694 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX 5.1 Original Version:   12.5.3 ESD#6 Fixed Version Build Resolution Date Closure Code (If Appropriate) 04 Feb 2007 Diagnostic Provided Description Instrumentation code added to collect specific data points when error 12318 occurs. A retry logic also has been added to regenerate the offset table for the index page in question to see if we can recover from this error. Diagnostic messages will be written to the errorlog. To turn off the retry logic use "DBCC traceon(625)".

CR:428757

CR Number:   428757 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.3 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 24 Apr 2006 Consult Complete Description The customer should run DBCC CHECKCATALOG with FIX option to fix the errors from collocate(), both in the sort code and checktable code paths. This should be done prior to running sp_post_xpload. Workaround Description  Drop the problem index from the source ASE before dump the database or drop and recreate the problem index after 1505 error after xpload. (have ask for the exact create index syntax the TSE used on the customer site as Shampa suggested)

CR:428893

CR Number:   428893 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 07 Aug 2007 Fixed 19 Sep 2007 Fixed Description Provide object id and page number in addition to text pointer value for messages 7123, 7125, 7126, 7127, 7128, and 7134.

CR:428915

CR Number:   428915 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   Galaxy Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Aug 2006 Fixed Description When a database fails recovery because one or more of its devices do not start correctly, or when there are I/O errors on a device such that a database becomes unusable, DROP DATABASE will not drop that database.

CR:428922

CR Number:   428922 Product Name:   Adaptive Server Enterprise Product Component:   MDA/Monitoring Tables Status:   Closed OS:   Solaris Original Version:   12.5.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 24 Jan 2007 Fixed 17 May 2006 Deferred 12 Feb 2007 Fixed 02 Apr 2007 Fixed 07 Feb 2007 Fixed 15 Jun 2007 Fixed 11 Jun 2007 Fixed 18 Jul 2007 Fixed 24 Jul 2007 Fixed 30 Jun 2011 Fixed Description Enhancement to sp_monitor to monitor deadlocks using monDeadLock monitoring table. Interface is "sp_monitor 'deadlock'", followed by various arguments. An archival facility is provided to store deadlock events in a user-specified table. Detailed usage information can be obtained from: "sp_monitor help, deadlock" comand. Connection monitoring is now enhanced with new command "sp_monitor procstack", that reports on a task's procedural execution stack. Use "sp_monitor help, procstack" for more details.

CR:428932

CR Number:   428932 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.3 ESD#6 Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 Jul 2012 Insufficient priority to fix Description Feature request : DISK INIT permits us unspecified device size on raw devices. If device size is not specified, DISK INIT command automatically recognizes size on raw devices.

CR:428948

CR Number:   428948 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 Oct 2006 Presently Not Targeted For Any Future Release Of This Product 25 Sep 2006 Fixed Description Invalid dbid passed to built ins will report error 913 with higher severity.

CR:428963

CR Number:   428963 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 05 May 2006 Fixed Description The error 644 "Index row entry for data row id ... is missing from index page ... of index id 2 of table 'syscolumns' ..." may be reported when a syscolumns row is being updated in the deferred mode as shown by sp_showplan and the row being updated is the forwarded location.

CR:429009

CR Number:   429009 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.3 ESD#6 Fixed Version Build Resolution Date Closure Code (If Appropriate) 27 Jul 2009 Fixed 29 Jul 2009 Fixed 19 Aug 2009 Fixed Description Occasionally on a multi-engine system, sp_monitorconfig "Active procedure cache" values might be higher than configuration value

CR:429010

CR Number:   429010 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 06 Jul 2006 Fixed Description Added support of auto-parametize univarchar literals for statement cache, so the following two statements will be sharing the same query plan: select * from unitb where unicol = U&'\20ac' select * from unitb where unicol = U&'5493\4e54'

CR:429036

CR Number:   429036 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   all Original Version:   Galaxy Fixed Version Build Resolution Date Closure Code (If Appropriate) 30 Aug 2006 Fixed Description bcp wizard usibility improvments

CR:429128

CR Number:   429128 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Microsoft Windows Original Version:   12.5.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 10 May 2006 Fixed 15 May 2006 Fixed Description In rare situations during ASE shutdown a stack trace may be seen showing a storage access violation in ntdll.dll (this only affects ASE running on Windows systems).

CR:429252

CR Number:   429252 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 04 May 2006 Fixed 26 May 2006 Fixed Description When the statement cache is configured for Adaptive Server, the bcp 'out' command used with the '-C' flag fails with Msg 225 when copying out encrypted data.

CR:429253

CR Number:   429253 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Microsoft Windows NT Original Version:   12.5.3 ESD#6 Fixed Version Build Resolution Date Closure Code (If Appropriate) 01 Jun 2006 Fixed Description Adaptive Server Enterprise running on the Windows operating system does not correctly handle device file names when those names (or directory paths) contain characters outside of the standard ASCII range 32-126, depending on the local character set in use. CR 429253 fixes this issue when used in conjunction with isql -J which disables character set conversion between isql and ASE.

CR:429295

CR Number:   429295 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 Jun 2006 Fixed 05 Jun 2006 Reservation Made Description Stack trace associated with error 14127 "Cannot drop or modify partition descriptor ... as it is in use. Please retry your command later. Total reference count ... Task reference count ..." May be seen rarely when create placement index command is rolled back for resources reason. Workaround Description  No workaround.

CR:429350

CR Number:   429350 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   Microsoft Windows Original Version:   15.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 04 May 2006 Fixed Description Web services folder does not open when ASE Plug-in is connected to pre 15.0 servers. It gives a stack trace when an attempt is made to open this folder.

CR:429457

CR Number:   429457 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 27 Apr 2006 Not a Bug Description enhancement request where 'rowcnt' in ASE 15 is changed to 'ROW_COUNT'

CR:429480

CR Number:   429480 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   Galaxy Fixed Version Build Resolution Date Closure Code (If Appropriate) 28 Apr 2006 Fixed Description set option show_missing_stats on reports missing stats on columns with BIT datatype, which is noise, since update statistics cannot be done on BIT datatypes

CR:429481

CR Number:   429481 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) 17 May 2006 Fixed 18 May 2006 Fixed Description An outer join query with an ON clause containing a join condition with constants would stack trace. An example of such a query would be: SELECT * FROM (SELECT 1 AS Col1) TableA LEFT JOIN (SELECT 1 AS Col2) TableB ON 1=2

CR:429483

CR Number:   429483 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 01 May 2006 Fixed 01 May 2006 Fixed Description When printing messages, the preupgrade utility refers to the new version's names for configuration variables. If a config has been renamed, this causes it to print the name of a config that does not exist in the old installation.

CR:429499

CR Number:   429499 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.4 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 03 May 2006 Fixed 03 May 2006 Fixed Description Errors 950 and 5903 maybe given when dropping an encryption key if one of the databases is offline. Warning 15427 should be given instead and the key should be dropped.

CR:429601

CR Number:   429601 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   all Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 03 May 2006 Fixed 18 Jun 2006 Fixed Description When a user generates DDL for database objects, a dialog shows up to allow user to exclude certain objects for DDL generation. The objects would be incorrectly selected when Table is selected and the list is sorted by clicking the column header. This has been corrected.

CR:429620

CR Number:   429620 Product Name:   Adaptive Server Enterprise Product Component:   MDA/Monitoring Tables Status:   Closed OS:   Solaris Original Version:   15.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 10 May 2006 Fixed 15 Sep 2006 Insufficient priority to fix Description A stacktrace may occur when a query is executed on the monProcessObject MDA table.

CR:429624

CR Number:   429624 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 May 2006 Fixed 03 May 2006 Fixed Description If a Lava parallel query terminates abnormally, then a SEGV could occur in terminate_process() effectively shutting down the server engines.

CR:429679

CR Number:   429679 Product Name:   Adaptive Server Enterprise Product Component:   sybmigrate Status:   Closed OS:   all Original Version:   12.5.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 25 May 2006 Fixed 15.0.1 31 Aug 2006 Fixed Description 1) The message "SELECT permission denied on object <keyname>, database <dbname> owner <ownername>" will be reported in the errorlog when a user with sso_role specifies a column for encryption on a SELECT INTO statement. 2) When the "CREATE" audit option is set, encrypted column names and key names are not added to the extrainfo column of the audit log for the SELECT INTO statement.

CR:429755

CR Number:   429755 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 04 May 2006 Fixed 04 May 2006 Fixed Description The message "current process infected with 11" in the module 'void CgpPop::setDataIOHints(int,int,int)' may be reported in the error log if a query uses TOP on a local index.

CR:429764

CR Number:   429764 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   Windows XP Original Version:   12.5.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 09 May 2006 Fixed Description After creating a compiled object (view, stored procedure etc) in ASE Plug-in through the template, the next time when you try to bring up the template for creation of a new object of the same type, the template does not come up

CR:429806

CR Number:   429806 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 03 May 2006 Fixed 03 May 2006 Reservation Made 03 May 2006 Fixed 04 May 2006 Fixed Description Queries involving constant predicates under OR (e.g. 1=@v1 OR r.a=5) could result in poor performance since the selectivity of the constant predicate (1=@v1) was not accounted for resulting in possible poor join orders. Magic numbers are now used for the constant predicates.

CR:429864

CR Number:   429864 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 03 May 2006 Fixed 03 May 2006 Presently Not Targeted For Any Future Release Of This Product Description A SELECT * from monLicense in a multi-engine configuration could result in a stack trace which includes VTABRemoteAccess::mdaStartScan.

CR:429886

CR Number:   429886 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   all Original Version:   15.0 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 08 May 2006 Fixed Description Previously ASE Plug-in did not close connections to Unified Agents, causing the agents to potentially run out of memory. Now ASE Plug-in explicitly closes all its connections to the agents when Sybase Central exits. Note this may cause a slight delay in closing Sybase Central.

CR:429965

CR Number:   429965 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 09 May 2006 Fixed Description sp_chgattribute does not allow you to set identity_burn_max to 0 leading to first identity value of 2.

CR:429968

CR Number:   429968 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Windows XP Original Version:   15.0 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16 May 2006 Fixed Description A select from a very large table with an IN list greater than 40 may fail with a stack trace that includes CgLavaUtils::CgCompVirtualCol. Workaround Description  When the query is preceded by set group_hash 0; query executes OK. when statistics from table index are deleted; query executes OK.

CR:429969

CR Number:   429969 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Jun 2006 Fixed 20 Jun 2006 Presently Not Targeted For Any Future Release Of This Product 17 Aug 2005 Presently Not Targeted For Any Future Release Of This Product Description Error message 5018, "Caution: You have set up this database to include space on disk <n> for both data and the transaction log." may be raised in error during CREATE, ALTER or LOAD DATABASE if the database has any disk fragments allocated on virtual devices between 248 and 255.

CR:429997

CR Number:   429997 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16 Dec 2006 Fixed 18 Dec 2006 Fixed 31 May 2007 Fixed Description In 12.5 expression histogramming was used on LIKE predicates to estimate selectivity of predicates which did not have limiting sargs. A query such as... select count(*) from t1,t2 where t1.a2 LIKE "%abc" and t1.a1=t2.b1 would have no limiting sargs since the wildcard at the beginning of the LIKE expression precludes this, yet the histogramming can still be applied, by evaluating each histogram boundary value with the LIKE expression. In 15.0 expression histogramming was extended to all predicates that were not sargs, including LIKE predicates, to estimate the selectivity. The improved selectivity estimate should result in better join order selection.

CR:430088

CR Number:   430088 Product Name:   Adaptive Server Enterprise Product Component:   backup server Status:   Closed OS:   Digital UNIX Original Version:   12.5.3 ESD#6 Fixed Version Build Resolution Date Closure Code (If Appropriate) 24 Jul 2006 Fixed Description Backup Server process dies on HP Tru64 when a child sybmultbuf process dies or is killed. Workaround Description  None known.

CR:430101

CR Number:   430101 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   all Original Version:   12.5.4 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 03 Aug 2006 Fixed 31 Aug 2006 Fixed Description Sybase Central ASE Plug-in from 12.5.4 ESD#2 supports load transaction for archive databases.

CR:430103

CR Number:   430103 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 06 Jul 2006 Fixed 30 Aug 2006 Fixed 06 Jul 2006 Reservation Made 03 Jan 2007 Presently Not Targeted For Any Future Release Of This Product Description A convenient method for an administrator to look at logged-in spids, to determine which authentication mechanism (Kerberos, PAM, LDAP, ASE) was used for the login is needed. Workaround Description  Only workaround for now is use dbcc 4001 on the ASE and look for Kerberos logins but this does not handle LDAP where login has fallen back to ASE etc.

CR:430126

CR Number:   430126 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   Galaxy Fixed Version Build Resolution Date Closure Code (If Appropriate) 04 May 2006 Fixed 05 May 2006 Fixed Description Cntr-C did not interrupt a long compilation prior to this bug fix, and would only be processed once the compilation was complete

CR:430136

CR Number:   430136 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   SunOS Original Version:   Galaxy Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 May 2006 Fixed Description No best plan found when user specifies potential conflicting optgoal and optimization criteria. For example, use allrows_oltp optgoal and turn off nljoin at the same time could sometimes lead to the case because the only viable join operator for some query under the optgoal would be nljoin.

CR:430147

CR Number:   430147 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 09 May 2006 Fixed 09 May 2006 Fixed Description Wrong result (missing rows) could happen for query INSERT ... SELECT DISTINCT ... ORDER BY which also satisfies: 1. there is some expression as part of the SELECT DISTINCT items. 2. some ORDER BY items are NOT part of the SELECT DISTINCT items.

CR:430169

CR Number:   430169 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Windows W2k Original Version:   12.5.3 ESD#6 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15 Jun 2006 Fixed 02 Oct 2006 Fixed Description ASE running on the Windows platform may display a stack trace terminating with "NULL PSS on stack overflow" in the event that shared memory cannot be allocated at startup. Note that failing to allocate shared memory (maybe due to machine resource limitations) will always prevent ASE startup but should not cause the stack trace. Workaround Description  The shared memory allocation failure is the real problem which needs to be solved.

CR:430251

CR Number:   430251 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 09 May 2006 Fixed Description In rare occasions, error 1156 may be reported and stack trace occurs when trace 2901 is on when create placement index command fails due to resources reason. Workaround Description  No workaround.

CR:430253

CR Number:   430253 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   all Original Version:   Galaxy Fixed Version Build Resolution Date Closure Code (If Appropriate) 04 Jan 2008 Fixed Description Planviewer used to perform poorly for stored procedures, since it did not make use of the cost section of the plan. This was because the tool assumed that the cost section of the plan was not accurate. However the reality was that the cost section is accurate. Planviewer is fixed to make use of this section, hence its performance is enhanced.

CR:430259

CR Number:   430259 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   12.5.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 08 May 2006 Fixed 08 May 2006 Fixed Description Update sqldbgr script to reflect the latest updates to shared directory sctructure.

CR:430304

CR Number:   430304 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 24 May 2006 Fixed Description Using the SET option PROC_OUTPUT_PARAMS to switch off the output parameters being returned by the outermost stored procedure, will cause incorrect results when multiple stored procedures are nested and returning output parameters.

CR:430305

CR Number:   430305 Product Name:   Adaptive Server Enterprise Product Component:   DDLGen Status:   Closed OS:   Linux Original Version:   15.0 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Jul 2006 Fixed Description DDLGen does not generate the following attributes when generating DDL for a cache - partition number and cache replacement policy.

CR:430337

CR Number:   430337 Product Name:   Adaptive Server Enterprise Product Component:   mscs_ha Status:   Closed OS:   Windows W2k Original Version:   12.5.3 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Feb 2012 Workaround Description SYBCPNRESDLL missing text from entries in the Event Application log

CR:430347

CR Number:   430347 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15 Dec 2006 Fixed 06 Apr 2007 Presently Not Targeted For Any Future Release Of This Product 13 Dec 2007 Insufficient priority to fix Description When updating a record with timestamp column by "update .. where current of cursor_name" and the timestamp column is in the SELECT list, 594 error is raised.

CR:430394

CR Number:   430394 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 03 Nov 2006 Fixed 05 Aug 2008 Presently Not Targeted For Any Future Release Of This Product Description WHen large buffer pools are used, then there may be a tendency to be overoptimistic on the PIO savings from large IOs, even though there is a weak data page cluster ratio for the index. The correction is that more PIO will be estimated due to a poor data page cluster ratio that indicates that data pages are not well clustered for the index scan.

CR:430423

CR Number:   430423 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Windows W2k Original Version:   15.0 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 07 Jun 2007 Fixed Description Occasionally, a shared intent table lock on SYSSTATISTICS table might be seen being held continuously by license heartbeat process when sp_lock is executed.

CR:430428

CR Number:   430428 Product Name:   Adaptive Server Enterprise Product Component:   FTS SDS Status:   Closed OS:   Solaris Original Version:   12.5.3 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 09 Feb 2007 Fixed 09 Feb 2007 Fixed 15 Feb 2007 Fixed Description modify sp_text_load_index to display progress messages

CR:430433

CR Number:   430433 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 May 2006 Fixed 12 May 2006 Fixed Description Error 940 "Dbtable in wrong state for operation: ... keep = 0 ..." may be reported in the error log in module "dbt_unkeep" during the execution of an UPDATE command whose trigger has a cursor statement that references TEXT/IMAGE columns. The modules "xact_commit" and "xact_end_session" will also be reported in the stack trace.

CR:430483

CR Number:   430483 Product Name:   ASE Replicator Product Component:   Distributor Status:   Open OS:   Generic Original Version:   15.0.0.400 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.0.1.411P2 19 May 2006 Fixed 15.0.1.411P2 15.0.1.411P2 Description ASE REPLICATOR: In an environment with a large number of subscriptions, 'sp_resumeXXX' command may fail to resume a subscription or primary connection; the status will not change from 'DOWN' to 'UP'. The condition may indicate that the maximum number of threads used by Replicator has been reached. The maximum number of threads limit may be increased using 'sp_configrep' command with the new 'max_threads' configuration parameter.

CR:430496

CR Number:   430496 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 22 Jun 2006 Fixed 21 Jul 2006 Fixed Description When a database is bound to a named cache and that database is upgraded, the upgrade succeeds but ASE will report error 858, "Cache [name] does not exist" for that cache. The upgrade utility records this message as a failure.

CR:430503

CR Number:   430503 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Windows W2k Original Version:   12.5.2 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 30 Oct 2006 Insufficient info provided 11 Jun 2006 Consult Complete 20 Mar 2007 Consult Complete 05 Mar 2007 Fixed 08 Mar 2007 Fixed Description An INSERT/DELETE/UPDATE trigger interrupted by Ctrl C may not qualify the expected number of rows from the INSERTED/DELETED table and the associated INSERT/DELETE/UPDATE statement may not be rolled back accordingly.

CR:430551

CR Number:   430551 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Microsoft Windows Original Version:   12.5.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 01 Jun 2006 Fixed Description Adaptive Server Enterprise running on the Windows operating system may encounter 'invalid handle exception' during shutdown.

CR:430552

CR Number:   430552 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) 15.0.2 22 May 2006 Fixed 25 Sep 2006 Fixed 09 Sep 2007 Fixed Description Deadlocks on system catalogs due to two parallel tablescans on syscolumns. These deadlocks are exposed because the table locks are removed as part of the project.

CR:430553

CR Number:   430553 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.3 ESD#6 Fixed Version Build Resolution Date Closure Code (If Appropriate) 21 May 2006 Consult Complete 28 Aug 2006 Fixed Description An unexpected 557 error "The cursor '<cursor name>' can not be used as it could not be found. It is possible that either it was not declared or it is not available in the current context." may be raised or the message "current process infected with 11" in the module 'execudf' may be reported in the errorlog if a JAVA user defined function that uses the internal JDBC ASE driver is executed a high number of times (more than 30000) by the same connection and at the same time one or more cursors are active on that particular connection.

CR:430555

CR Number:   430555 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 New Feature Request to add severity level to raiserror and sp_addmessage commands. Workaround Description  None known.

CR:430559

CR Number:   430559 Product Name:   Adaptive Server Enterprise Product Component:   diagserver Status:   Closed OS:   HP-UX Original Version:   15.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 23 May 2006 Fixed Description Staled buffer could be used for index building, and wrong page could be used in index chain, raising wrongpage error or wrong ptnid error (12329 error).

CR:430568

CR Number:   430568 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) 18 Jul 2008 Fixed 28 Jul 2008 One-off Provided 18 Jul 2008 Fixed Description Feature request to increase or eliminate the current limit of 48 on number of execution classes.

CR:430573

CR Number:   430573 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 26 May 2006 Fixed 26 May 2006 Presently Not Targeted For Any Future Release Of This Product Description On 64-bit sytems sometimes the message "current process infected with 10" in the module 'des_getval' together with a stack trace which includes the modules 'd_procbuf' and 'exec_dbcc' maybe be reported in the errorlog when DBCC PROCBUF command is executed.

CR:430582

CR Number:   430582 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Jun 2006 Fixed Description A SQL query with a correlated subquery can cause a stack trace to happen, when run under parallel mode. If the same query is made to run in serial mode, it works fine.

CR:430597

CR Number:   430597 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   all Original Version:   15.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 May 2006 Fixed Description In Sybase Central ASE Plug-in, when repartitioning a table with list partition strategy, you may get an 'Incorrect syntax error' if in the list partition spec dialog you enter blank values for the list partition set of values.

CR:430615

CR Number:   430615 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 May 2006 Fixed 03 Jan 2007 Fixed Description An UPDATE or DELETE query with the outer join updating the inner table should not be executed. Error 7720 "Update/Delete from a table which is the inner table of an outerjoin is not allowed. Command aborted." should be raised.

CR:430619

CR Number:   430619 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   all Original Version:   15.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 May 2006 Fixed Description NullPointer seen when call Tool->datatypes from Table Editor.

CR:430630

CR Number:   430630 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 May 2006 Fixed Description Aggregate(s) in a subquery could generate an incorrect parallel plan and caused stacktrace from LePipeRWState::LePrwsRWVtuple(LeVtuple*,pipe_client_rwmode,int) during execution.

CR:430633

CR Number:   430633 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 May 2006 Fixed 23 May 2006 Fixed Description When a query plan has several occurences of a table for a single table occurence in the query's FROM list (as for non-combinable aggregates, extended columns aggregation, GROUP BY ALL, etc.), the Abstract Plan has no way to distinguihs between them. We need to generate unique internal names in such a case to be able to apply lated such an AP.

CR:430655

CR Number:   430655 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) 09 Aug 2006 Fixed Description In XML diagnostic outputs alias names would be printed along with table names.

CR:430703

CR Number:   430703 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Dec 2006 Fixed Description When sending an RPC using cis rpc handling, if the rpc name length is greater than 30 bytes, an internal protocol error would result. This has been fixed in ASE 15.0.2

CR:430714

CR Number:   430714 Product Name:   Adaptive Server Enterprise Product Component:   MDA/Monitoring Tables Status:   Closed OS:   NA Original Version:   15.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 31 Oct 2006 Fixed Description The monOpenObjectActivity MDA table did not correctly distinguish the occurrence of table scans from clustered index usage on tables containing clustered indexes. Clustered index usage and table scans are now reported correctly.

CR:430743

CR Number:   430743 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.3 ESD#7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 25 Aug 2006 Not a Bug Description Import of abstract plans into another db does not work on 12.5.3 - 32bit

CR:430748

CR Number:   430748 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.3 ESD#6 Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Apr 2007 Fixed 24 Aug 2007 Fixed Description Instrumentation to diagnose 12328 errors: "The calculated row offset '<offset>' of an index key on page '<pageid>' for object '<objid>'in database '<dbid>' is out of bounds (table offset on page = '<offset>', page status = '<pgstat>', local offset table address = <address>). Also, regenerate the offset table once to try to avoid 12328 errors, unless command line trace flag 625 is turned on.

CR:430808

CR Number:   430808 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   12.5.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 May 2006 Fixed 01 Jun 2006 Presently Not Targeted For Any Future Release Of This Product 07 Jun 2006 Fixed Description The following platforms are unable to set the minimum value for sp_ldapadmin set_max_ldapua_native_threads attribute to less than fifteen: Sun Solaris, IBM AIX, HPUX, Windows, Tru64.

CR:430859

CR Number:   430859 Product Name:   Adaptive Server Generic Docs Product Component:   System Administration Guide Status:   Closed OS:   all Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 07 Aug 2007 Added to user documentation Description event 86 builtin functions is not clearly documented.

CR:430862

CR Number:   430862 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   Windows W2k Original Version:   15.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 May 2006 Fixed Description The Job Scheduler Administration window always reports that the Job Scheduler is running, even when it is stopped.

CR:430867

CR Number:   430867 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16 Oct 2006 Fixed 14 Oct 2006 Fixed 02 May 2007 DEFER Description Nary-NLJs might return too few rows if they contain a filter predicate that contains an expression in an equijoin. The following query provides such an example: select * from a, b, c where a.a1 = b.b1 and a.a2 + b.b2 = c.c2 In this query, the predicate "a.a2 + b.b2 = c.c2" contains a virtual column "a.a2 + b.b2" as part of the equijoin. In this case, the nary-NLJ might skip processing some rows of b. Note that if the same predicate is written as a theta-join "a.a2 + b.b2 > c.c2", the correct result will be returned. Workaround Description  Use trace [commandline] flag 342 to disable nary-NLJ strategies.

CR:430868

CR Number:   430868 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 26 May 2006 Fixed Description When 'statement cache' is enabled and there are large in-lists (e.g. 15000 in-lists), timeslice error may occur.

CR:430886

CR Number:   430886 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Jun 2006 Fixed Description A sub-optimal plan with unnecessary I/Os may be chosen for some MIN/MAX queries with non-equiSARGs (eg: column < constant) on the aggregate column. Use switch 390 to enable the fix.

CR:430892

CR Number:   430892 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 24 May 2006 Fixed 02 Jan 2007 Fixed Description sp_cacheconfig will display wash size as '****** Kb' if the number of digits in the wash size is greater than 6. Workaround Description  When we execute 'sp_cacheconfig' a temporary table called '#pool_detail' and the following insert is executed to add rows to it: insert #pool_detail values (@sysconf_name, replicate(" ", 6 - (charindex("K", @io_sz_comment))) + substring(@io_sz_comment,1, charindex("K",@io_sz_comment)-1) + " Kb ", str(@wash_size,6) + " Kb", rtrim(str(convert(float,@config_size) / 1024, 9, 2)) + " Mb", rtrim(str(convert(float,@run_size) / 1024, 9, 2)) + " Mb", @pool_status, str(@apf_value, 6)) The problem on this statement is on 'str(@wash_size,6)'. On this way, they report '******' to wash size. If we change this to 'str(@wash_size,9)' then the report will be correct (1000000). I changed 'sp_cacheconfig' on this way and now it is reporting the correct value: Cache Name Status Type Config Value Run Value ---------- ------ ---- ------------ --------- default data cache Active Default 1464.84 Mb 1464.84 Mb IO Size Wash Size Config Size Run Size APF Percent ------- --------- ----------- -------- ----------- 2 Kb 1000000 0.00 Mb 1464.84 Mb 10 Then this could be a possible workaround.

CR:430902

CR Number:   430902 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   12.5.3 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 Jun 2006 Fixed 16 May 2006 Not reproducible with latest version of the product available as of Resolution Date Description CIS: In some scenarios, query with a LIKE clause and builtin functions may prevent some search conditions to be sent to the remote server. Workaround Description  Suggested workarounds. Use a variable on the like constant or getdate() : declare @v varchar(100) select @v = 'BRACOMMON%' select sa.*, ct.searchname from searchamerica..archsearchaudit sa, congo..track ct where 1=1 and sa.lname like @v and sa.date >= dateadd(day,-365,@d) and ct.trackid = sa.trackid order by date desc go declare @d smalldatetime select @d = getdate() select sa.*, ct.searchname from searchamerica..archsearchaudit sa, congo..track ct where 1=1 and sa.lname like('BRACOMMON') and sa.date >= dateadd(day,-365,@d) and ct.trackid = sa.trackid order by date desc go

CR:430940

CR Number:   430940 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UX Original Version:   15.0 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 May 2006 Fixed 17 May 2006 Fixed 17 May 2006 Fixed Description There was a problem in the hash distinct and hash aggregation operations when processing large datasets. This could possibly lead to duplicate rows in the distinct case and/or incorrect row interpretation in the aggregation case.

CR:430993

CR Number:   430993 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) 22 Nov 2006 Fixed Description An error 9972, "An error 247 occurred while inserting the results into the dbcc_counters table" together with error message 247 "Arithmetic overflow during implicit conversion of INT value '576002052' to a SMALLINT field" in error log will be reported when running "dbcc checkstorage" if installdbccdb script is not installed in master database.

CR:431016

CR Number:   431016 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   macosx Original Version:   12.5.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Jun 2006 Fixed 15 Jun 2006 Fixed 16 Jun 2006 Fixed Description On MAC, ASE may start with incorrect IP address due to race condition at startup.

CR:431034

CR Number:   431034 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   SunOS Original Version:   12.5.3 ESD#7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 29 May 2009 Duplicate Description Wants the ability to run specific stored procedures or SQL in parallel. My idea was the following: 1) Add an sp_configure option called 'restrict parallel execution' - 0 meaning no restrictions, 1 meaning only specific users could run in parallel. 2) Add a security role 'pqe_role' so that users could use the 'parallel' keyword on queries and 'set parallel_degree', 'set scan_parallel_degree' for sessions. What would happen: If 'restrict parallel execution' was equal to zero (0) then the system would function as it does now. 'max parallel degree' and 'max scan parallel degree' would determine whether or not queries ran in parallel. If 'restrict parallel execution' was equal to one (1) then the system would not allow users without the 'pqe_role' to run any query in parallel. If a user had the role enabled they would then need to specify the 'parallel' keyword in the query or set parallelism using the 'set parallel_degree' and/or 'set scan_parallel_degree' for the session. Sequence to Enable for SA user: sp_configure 'restrict parallel execution',1 go sp_configure 'max parallel degree',50 go sp_configure 'max scan parallel degree',20 go sp_role 'grant', pqe_role, sa go sp_modifylogin sa 'add default role', pqe_role go

CR:431037

CR Number:   431037 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) 12 Jun 2009 Insufficient priority to fix Description Customer needs method to retrieve default value of parameter from stored procedure

CR:431082

CR Number:   431082 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.3 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 25 May 2006 Fixed 19 May 2006 Fixed 14 Nov 2006 Presently Not Targeted For Any Future Release Of This Product Description DBCC checkalloc may report transient 2529, 7989 and 2540 errors after DBCC checkcatalog(<DBNAME>, fixall) has been used to correct Sysindexes descrepancies.

CR:431084

CR Number:   431084 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   NA Original Version:   15.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 May 2006 Fixed Description A java.lang.NullPointerException is thrown if the user selects the key checkbox on the column encryption tab (within column properties) and subsequently selects the property button.