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

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

CR:438358

CR Number:   438358 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) 13 Dec 2006 Duplicate Description sp_listener does not supply its subcommands when called without arguments. Workaround Description  Rewrite the sproc yourself to do it.

CR:438389

CR Number:   438389 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UX Original Version:   15.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 21 Aug 2006 Not a Bug 11 Aug 2006 Fixed Description SEGV could happen in LeHashContext when executing a nested outerjoin query involving remote tables.

CR:438406

CR Number:   438406 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   Microsoft Windows NT Original Version:   15.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 01 Dec 2006 Fixed Description Fail to download report log file when the SC client and SYSAM server are on different machines.

CR:438458

CR Number:   438458 Product Name:   Adaptive Server Enterprise Product Component:   InstallShield Status:   Closed OS:   all Original Version:   15.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 31 Jul 2006 Duplicate Description When building server from installer of ASE, installer uses 120MB as a default value of sybsystemprocs as a wrong value. Workaround Description  Please select custom installation. As for default value, 132MB is used.

CR:438509

CR Number:   438509 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   12.5.3 ESD#7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 10 Aug 2006 Fixed Description An UPDATE may incorrectly set varchar column to NULL value instead of a single space. This happens if the UPDATE is executed in the stored procedure and the value to be set is passed as the procedure parameter and represents a string of spaces. This problem happens only if the option string_rtruncation is set. Workaround Description  Each of the workarounds listed below can be used. a) When using -G parameter for ESQL, the length of the variable that is used to update the column should not be bigger than the column size. b) Use trace flag 7709. c) Do not use CS_OPT_STR_RTRUNC in ESQL or set string_rtruncation.

CR:438558

CR Number:   438558 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.3 ESD#7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 01 Aug 2006 Fixed Description The error 678 "Invalid Buffer Cache Access: Could not open object <value> in database <value>" may be raised followed by the message "Illegal attempt to rollback transaction (xactname '$chained_transaction') that has already committed" when committing a transaction that has a select into command followed by a drop of the table just created. The problem is restricted to use of large page allocation, objects with Data-Only-Locking, databases with "ddl in tran" active and "set chained on" option. Workaround Description  Do not use datarows as the default locking scheme OR turn off large page allocations with trace flag 1101 OR make the select into cmd produce an APL vs. DOL table (into #test lock allpages)

CR:438569

CR Number:   438569 Product Name:   Adaptive Server Enterprise Product Component:   InstallShield Status:   Closed OS:   all Original Version:   15.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 Nov 2006 Fixed 21 Nov 2006 Presently Not Targeted For Any Future Release Of This Product 22 Nov 2006 Fixed 29 Nov 2006 Fixed 20 Nov 2006 Fixed 30 Nov 2006 Presently Not Targeted For Any Future Release Of This Product 29 Nov 2006 Fixed 12 Aug 2007 Fixed Description In console mode installation, line up the list of location tidily on Japanese environment.

CR:438621

CR Number:   438621 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.1 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 Apr 2009 Duplicate Description Request a compilation option for stored procedures that would optionally convert non-existing static object syntax to dynamic execution for those objects. Prefer that the syntax changes to the stored procedure all be made transparent to the customer with suitable warnings. Workaround Description  Use existing static procedures with some dynamic syntax

CR:438656

CR Number:   438656 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX Original Version:   15.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 08 Sep 2006 Fixed 12 Sep 2006 Fixed 12 Sep 2006 Fixed Description Configuring ASE15.0.1 for High Availability on IBMAIX/HACMP cluster fails because the haisql binary cannot be loaded properly. Target Version  15.0.1 ESD#1

CR:438660

CR Number:   438660 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   NA Original Version:   12.5.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Aug 2006 Fixed 20 Nov 2006 Not a Bug 26 Sep 2007 Not a Bug Description SELECT queries may result in getting the system date, causing degradation in query performance.

CR:438703

CR Number:   438703 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.4 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15 Aug 2006 Fixed Description The option WITH NO_INFO is added to the SET SWITCH command syntax to suppress any informational warning being sent to the client. This option has only effect on informational warnings, error messages when necessary are still being raised. Workaround Description  n/a

CR:438705

CR Number:   438705 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UX Original Version:   12.5.3 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 21 Nov 2006 Fixed 02 Nov 2006 One-off Provided 16 Oct 2006 One-off Provided 25 Oct 2006 One-off Provided 22 Nov 2006 Fixed 22 Nov 2006 Fixed 15 Dec 2006 Fixed Description Under very rare circumstances, a 694 error reading "An attempt was made to read logical page '<Page Number', virtpage '<PageNumber>' from virtual device '<DeviceNumber>' for object '<ObjectId>' in database '<DbId>'. The page was not read successfully. You may have a device problem or an operating system problem." may be raised for a page belonging to the log segment.

CR:438707

CR Number:   438707 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) 15.0.1 ESD#1 29 Aug 2006 Fixed Description Fixed the segment fault(core dump) while discovering the interface from ldap server on sunx64 platform.

CR:438723

CR Number:   438723 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Microsoft Windows NT Original Version:   15.0 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 26 Jun 2007 Fixed Description ALTER TABLE may raise error 206 when adding or modyfying a column and defining a complex constrainst in the same statement. Workaround Description  Run two ALTER TABLE commands separating DEFAULT and CHECK creation

CR:438732

CR Number:   438732 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) 05 Sep 2006 Fixed Description Comments generated as part of template job commands in lanaguages that don't use spaces will not display properly in Template and Job wizard summarys.

CR:438748

CR Number:   438748 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   Windows XP Original Version:   12.5.4 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 25 Aug 2006 Fixed Description When user select 'No' on the change password option, when 'expire password' option is set, the connection is not released. This fix addresses this issue by closing the 'pre expired login connection'.

CR:438754

CR Number:   438754 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) 30 Aug 2006 Fixed 19 Sep 2006 Fixed 19 Sep 2006 Fixed Description Error 806: Severity 21: State 1 may occur in some rare cases due to exhaustion of time slice during rollback.

CR:438815

CR Number:   438815 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) 16 Aug 2006 Fixed 16 Aug 2006 Fixed 24 Aug 2006 Fixed 30 Aug 2006 One-off Provided Description In rare circumstances, The message "current process infected with 11" in the module 'LeHashContext::HashVtuple' together with a stack trace which includes the modules 'LeHashContext::GetNext' and 'LeHashContext::ProcessTuple' may be reported in the error log when tempdb is bound to a name cache and the ASE is using a HASH operator to execute the query. Other stack traces including modules like 'LeAlignedDataRow::readRow' and 'LeHashBufferReader::GetNext' are seen as well. The diagserver reports a 685 error. Workaround Description  Do not bind tempdb to a cache other than default data cache.

CR:438822

CR Number:   438822 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX Original Version:   15.0 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 04 Aug 2006 Fixed Description The message "The front end tool you are using does not support the feature of bulk insert from host, please use the proper tools for this command." may be raised followed by the message "current process ... infected with 11" in module bufauxuninstall() during a bulk insert operation.

CR:438848

CR Number:   438848 Product Name:   Adaptive Server Enterprise Product Component:   MDA/Monitoring Tables Status:   Closed OS:   Solaris Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 08 May 2007 Fixed Description On servers running multiple engines the data returned by queries on the monIOQueue Monitoring Table may be incomplete.

CR:438854

CR Number:   438854 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) 11 Aug 2006 Fixed 23 Aug 2006 One-off Provided 17 Oct 2006 Fixed Description A batch inserting data to the table which has a default referencing global variable may fail if there are some other global variables referenced in the same batch. Stack trace shows module subglobals(). Workaround Description  use statements accessing global variables ina separate batch : INSERT t1 (c1) VALUES (1) go SELECT @@rowcount go

CR:438858

CR Number:   438858 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) 17 Aug 2006 Fixed Description Error 14617: Severity 23: State 1, may occur when dbcc checkcatalog is executed due to a mismatch between the master device row location in sysdevices and the the corressponding anchor.

CR:438859

CR Number:   438859 Product Name:   Adaptive Server Enterprise Product Component:   backup server Status:   Closed OS:   Linux Original Version:   12.5.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 29 Jul 2009 Fixed Description The message "The database page size of 2048 bytes obtained from ASE is different from the database page size of -1024 bytes read from the dump header." appears in error at the end of the output for LOAD with LISTONLY against a remote backupserver.

CR:438941

CR Number:   438941 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.3 ESD#7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Nov 2006 Fixed 22 Nov 2006 Fixed 17 Aug 2005 Presently Not Targeted For Any Future Release Of This Product Description SUBQUERY: Occasionally, a sub-optimal plan is chosen when the query contains a subquery from an IF EXISTS clause. This is resolved under traceflag 15371. Workaround Description  There are several work-arounds: select @c = count(*) .... if(@c > 0) .... instead of if exists (select *...) The ct is currently using the following workarounds: Workaround #1 set forceplan on if exists (select 10 from SWIFT_PrimDocToDelDoc s (index I_DocID), AddDFMDoc d (index Index_4) where s.DocID=3227404 and s.IsTransact=1 and s.ID_MESS=d.ID_MESS and d.DFMDocID!=0) select 1 set forceplan off Workaround #2 if exists (select 10 from SWIFT_PrimDocToDelDoc s (index I_DocID), AddDFMDoc d (index Index_4) where s.DocID=3227404 and s.IsTransact=1 and s.ID_MESS=d.ID_MESS and (d.DFMDocID>0 OR d.DFMDocID<0)) select 1

CR:438980

CR Number:   438980 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) 31 Aug 2006 Fixed 12 Dec 2006 Fixed Description In 15 realeases (15.0.1 and earlier) queries with two or more outer joins may return wrong results (too many rows). This can occur when there is a predicate on the inner member of an outer join that will eliminate all null-supplied rows for that outer join. This predicate effectively "degenerates" the outer join into an inner join. If the predicates for the "degenerating" outer join should in turn degenerate another outer join, then wrong results could occur. For example, select * from (t1 left join t2 on t1.a = t2.b) -- OJ #1 left join t3 on t2.b = t3.c -- OJ #2 where t3.c = 5 In this query, the where-clause predicate "t3.c = 5" will eliminate all null-supplied rows from OJ #2. This in turn will result in all null-supplied rows from OJ #1 being eliminated. This problem has been fixed.

CR:439024

CR Number:   439024 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) 29 Aug 2006 Fixed Description When a table with a JAVA ADT computed column is marked for replication using sp_setrpetable, the JAVA ADT columns are internally set to no-computed column, which causes DML on this collumn to be returned with inaccurate results. Workaround Description  set the table replicated using sp_setreplicate sp_setreplicate object_name, {true |false} Set the text, image, or off-row object column replicated using sp_setrepcol, by entering:sp_setrepcol table_name [, column_name [, {do_not_replicate | always_replicate | replicate_if_changed} [, use_index ] ] ]

CR:439123

CR Number:   439123 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 Mar 2010 Fixed 02 Mar 2010 Reservation Made Description With low cardinality tables i.e. the number of rows is less than the number of steps in a histogram, then there is a possiblity of having a 1 row range density selectivity, where the range density should be 0.0 optcriteria cr439123 needs to be on to see the change. Workaround Description  Edit optdiag statistics

CR:439173

CR Number:   439173 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) 16 Aug 2006 Fixed Description An insert into a proxy table that has an identity column and is mapped to an ASE does not set @@identity on the local server.

CR:439198

CR Number:   439198 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Microsoft Windows Original Version:   15.0 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 31 Aug 2006 Fixed Description A stacktrace or error 325 (no legal plan found) could happen for a DISTINCT query on a UNION ALL derived table/view and the DISTINCT column is an expression from the UNION ALL. Workaround Description  Two suggestions: select count(distinct convert(varchar, num_seq_autoriz)) from (select ano_autoriz + convert(varchar, num_seq_autoriz), num_seq_autoriz from tb_xxx union all select ano_autoriz + convert(varchar, num_seq_autoriz), num_seq_autoriz from tb_xxx ) t go or select count(distinct teste) from (select convert(varchar, num_seq_autoriz) teste from tb_xxx union all select convert(varchar, num_seq_autoriz) teste from tb_xxx ) t go

CR:439200

CR Number:   439200 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) 18 Jul 2007 Duplicate Description Delete queries with group by aggregate in correlated subqueries may execute slower as compared to 12.5.

CR:439211

CR Number:   439211 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Microsoft Windows Original Version:   15.0 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Aug 2006 Fixed Description View containing subquery when called in select will cause infected with 11

CR:439236

CR Number:   439236 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   12.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16 Aug 2006 Fixed Description If statement cache is enabled, the value of the global variable @@error will be reset if it is accessed in a batch together with a statement that gets cached. Workaround Description  Place the select @@error out of the batch.

CR:439269

CR Number:   439269 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) 18 Aug 2006 Fixed Description A SELECT with ORDER BY on a bit column may return the rows in descending order if there are more than four columns of bit datatype.

CR:439273

CR Number:   439273 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) 05 Mar 2012 Not a Bug Description CREATE INDEX w/ SET STATISTICS IO on does not display logical reads only display write

CR:439391

CR Number:   439391 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) 20 Jul 2007 Fixed Description The message "Msg 701, Level 17, State 3: Server 'XXXX', Line 1: There is not enough procedure cache to run this procedure, trigger, or SQL batch. Retry later, or ask your SA to reconfigure ASE with more procedure cache." can be generated by queries involving UNION of a large number of tables. Workaround Description  session level set parallel_query off or set ase125_primed on server level dbcc traceon(15305)

CR:439399

CR Number:   439399 Product Name:   Adaptive Server Generic Docs Product Component:   To Be Determined Status:   Open OS:   all Original Version:   15.0.1 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Enhancement request for SPDC FAQ on Sybase Software Asset Management section: "How do I save multiple licenses to a single file"

CR:439445

CR Number:   439445 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.2 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 06 Oct 2006 Not a Bug Description Process hang in pg_oamscan_nextpage() and dol_oamscan_getnext() when using large data cache configuration.

CR:439457

CR Number:   439457 Product Name:   Adaptive Server Enterprise Product Component:   backup server Status:   Closed OS:   all Original Version:   15.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15 Aug 2006 Fixed 21 Aug 2006 Fixed Description Excessive character '&n' is included in starting message of backupserver.

CR:439503

CR Number:   439503 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 Aug 2006 Fixed 25 Aug 2006 Fixed Description Procedure cache memory allocation may fail in certain boundary cases, if procedure cache request results in a procedure cache pool growth after a new shared memory segment allocation.

CR:439537

CR Number:   439537 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) 30 Aug 2006 Fixed Description When unit specification is used with sp_configure to configure syb_sendmsg port number, the unit specification parameter is ignored and syb_sendmsg port number is set to zero.

CR:439573

CR Number:   439573 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UNIX Original Version:   15.0 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 30 Nov 2006 Fixed Description sp_deviceattr accepts directio=true even if the platform does not support directio. sp_helpdevice shows "directio on" for the device as if ASE supported directio on the platform, but ASE will activate the device using dsync on and deactivate using directio at startup. Workaround Description  Please ignore output from sp_helpdevice and check your ASE's errorlog.

CR:439603

CR Number:   439603 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) 24 Sep 2006 Fixed 06 Oct 2006 Fixed Description When estimating the selectivity for a local index, the qualifying pages is incorrect.

CR:439619

CR Number:   439619 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   all Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 10 Oct 2006 Bundled Request Description Previously on Connect dialog, if previously-connected server entry had been removed from interfaces file, OK button would not be enabled, even though the server name was filled in. The has been changed so that if previously-connected server entry no longer exists in the interfaces file, Connect dialog will leave the server name as blank.

CR:439804

CR Number:   439804 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) 18 Aug 2006 Fixed Description Wrong result could happen when a subquery is correlated to an outerjoin inner table.

CR:439836

CR Number:   439836 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   all Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 29 Aug 2006 Fixed Description UI: segment policy page format inconsistent

CR:439857

CR Number:   439857 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) 12 Sep 2006 Fixed 12 Sep 2006 Fixed Description Error 102 and 105 may occur when inserting a single or double-byte single quotation mark into a unicode character column on a proxy table.

CR:439895

CR Number:   439895 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) 31 Aug 2006 Fixed 29 Aug 2005 Bundled Request Description The error 1105, "Can't allocate space for object ..." may be incorrectly reported, if the "greedy allocation scheme" is enabled on a table that has text/image columns and non-clustered indexes that are affiniated to distinct user defined segments. Workaround Description  Turn off greedy allocation: dbcc tune(des_greedyalloc, dbid, tabname, 'off) To check if the greedy allocation caused any problem, verify the GAM by running: dbcc gam(dbid or dbname, 0, 0, 'fix') in single user mode.

CR:439908

CR Number:   439908 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) 13 Sep 2006 Presently Not Targeted For Any Future Release Of This Product Description Provide an uninstall script for sp_dbextend

CR:439942

CR Number:   439942 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.1 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 21 Aug 2006 Fixed Description QP metrics is enabled for the statements inside triggers

CR:439945

CR Number:   439945 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Sep 2012 Insufficient priority to fix Description enhancement request to remove the limit number of work table for derived tables

CR:440030

CR Number:   440030 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) 31 Aug 2006 Fixed Description When complex password policy option "disallow simple passwords" is set, ASE checks for login name contained in the password are case sensitive. With this fix, ASE will do a case insensitive comparision to avoid the use of login name with mixed upper and lower case letters in the password.

CR:440031

CR Number:   440031 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) 23 Aug 2006 Bundled Request Description When complex password policy options are set using sp_passwordpolicy, installmaster may fail with 9578, 17720 and 17231 error messages.

CR:440046

CR Number:   440046 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) 23 Aug 2006 Fixed Description When there are two different local variables used in both select list and order by list, query may generate wrong ordering based on select expression.

CR:440052

CR Number:   440052 Product Name:   Adaptive Server Enterprise Product Component:   langinstall Status:   Closed OS:   all Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Dec 2006 Fixed 20 Mar 2007 Fixed 07 Aug 2007 Added to user documentation 03 Aug 2007 Fixed 15 Oct 2007 Fixed 10 Oct 2007 Fixed Description ASE localization files are moved from $SYBASE/locales/{language}/{charset} directory to $SYBASE/$SYBASE_ASE/locales/{language}/{charset} directory in ASE 15.0.2 release.

CR:440065

CR Number:   440065 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   SunOS Original Version:   12.5.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 29 May 2009 Insufficient priority to fix Description Currently it is extremely difficult to determine how much procedure cache should be configured on any particular system. There is a rule of thumb equation to calculate it but it does not cover all types of allocations from that area, neither is it very accurate. The customer wants a simple way to determine how large the procedure cache should be and how many other items should be increased/reduced, i.e. sort buffers, for this to be tuned properly. What I recommend is a stored procedure similar to sp_sysmon that can be run to collect the following information: 1) Current usage, maximum usage, minimum usage 2) Number of allocations 3) Type of allocation 4) Who/what made the allocations (including size, date/time, spid, user name and command name). 5) Average size (mean) of the allocations 6) Standard deviation from the mean The stored procedure should be called sp_procmon with the following parameters: sp_procmon <duration> [sample rate] [output table] Duration is required and represents time in minutes. Sample Rate is optional and by default would be one tenth of the Duration time so that only ten samples would be taken. Output Table is optional and is for the raw data collected by sp_procmon. This is just a suggestion and as log as the outcome for the customer is a simple way to monitor and configure procedure cache size I don't think they would care how we implement this feature. Workaround Description  *** Saturday, August 19, 2006 4:01:59 PM *** cooperg *** Too cumbersome for customer as a lot is trial and error.

CR:440091

CR Number:   440091 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UX Original Version:   15.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 23 Aug 2006 Fixed Description Creation of jpubs database hangs due to running out of log space. Workaround Description  Change jpubs database size from 3MB to 4MB.

CR:440107

CR Number:   440107 Product Name:   Adaptive Server Enterprise Product Component:   DBISQL Status:   Closed OS:   Windows XP Original Version:   15.0 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 21 Aug 2006 Not a Bug Description DBISQL the print statement do not work after a select 1. DBISQL do not pickup the 2 Print in a batch like this. print "Print test 1" select "Select test 1"+ print "Print test 2" go

CR:440127

CR Number:   440127 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) 28 Aug 2006 Fixed Description When an external login is mapped to an ASE login with a different name, if the external login password is changed, it should be updated in the mapped login if there is a one-to-one relation, but this is not happenening. Workaround Description  Add each LDAP user to ASE and update all the permissions - this is a major administration effort for big shops.

CR:440142

CR Number:   440142 Product Name:   Adaptive Server Enterprise Product Component:   backup server Status:   Closed OS:   HP-UX Original Version:   12.5.4 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Jun 2007 Fixed 06 Apr 2008 Presently Not Targeted For Any Future Release Of This Product Description Backupserver hangs when accept() returns an unexpected return value such as ENETRESET or ENOBUFS.

CR:440159

CR Number:   440159 Product Name:   Adaptive Server Enterprise Product Component:   syconfig - PC Status:   Closed OS:   Windows W2k Original Version:   12.5.4 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 08 Mar 2007 Fixed 21 Apr 2008 Fixed Description syconfig.exe utility shows corrupted Chinese characters when the default language is set to Traditional Chinese.

CR:440172

CR Number:   440172 Product Name:   XML Model Product Component:   XML Model Status:   Closed OS:   Windows XP Original Version:   telemaque Fixed Version Build Resolution Date Closure Code (If Appropriate) 01 Sep 2006 Fixed 01 Sep 2006 Fixed Description Select object doesnt show complex type either from same model or another model

CR:440175

CR Number:   440175 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) 30 Aug 2006 Fixed Description LDAP or PAM logins that were added using ASE older than 12.5.4 will not allow external authentications to failover to ASE logins, if authenticated by ASE 12.5.4 or later

CR:440204

CR Number:   440204 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) 06 Sep 2006 Fixed Description There is no password related audit option.

CR:440232

CR Number:   440232 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   Windows XP Original Version:   12.5.4 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 30 Aug 2006 Fixed Description In 12.5.4, ASE Plug-in failed to re-open "Add Trigger (Template)", after a trigger has been created using the template. This problem is seen for all compiled objects - defaults, rules, procedures etc. when a template is used for creation of these objects.

CR:440252

CR Number:   440252 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   all Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 23 Aug 2006 Fixed Description ASEP used to show no ASEs in the drop down box on Connect dialog if user's interfaces file contains any line that has white characters between "query" and "=". This has been fixed.

CR:440272

CR Number:   440272 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.0.1 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 30 Nov 2006 Fixed Description DBCC LOGTRANSFER may interrupt scanning the transaction log, or report the error "Character or binary data returned from Adaptive Server has been truncated. The client application does not support more than 255 bytes of data as a result column or output parameter." when it skips a log record with object identifiers larger than 30 characters.

CR:440278

CR Number:   440278 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) 31 Aug 2006 Fixed Description sp_droplogin fails to delete related Sysresourcelimits row when the configuration option 'enable ldap user auth' is on.

CR:440282

CR Number:   440282 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) 31 Aug 2006 Fixed Description The minimum expansion size of Automatic Database Expansion is 4MB.

CR:440382

CR Number:   440382 Product Name:   SySAM Product Component:   FLEXlm Status:   Closed OS:   Microsoft Windows NT Original Version:   12.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 May 2008 Insufficient priority to fix Description Contents written to "Provides" of StartupParameters.plist file are wrong. Workaround Description  Please rewrite Provides name to "SybaseLicenseManager".

CR:440393

CR Number:   440393 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) 31 Aug 2006 Fixed Description Wrong result may be returned from a select when unsigned bigints are compared in a where clause.

CR:440401

CR Number:   440401 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.0.1 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 25 Aug 2006 Fixed 29 Aug 2006 Fixed Description Lack of disk buffers, in some rare cases, may result in a segmentation violation during a create database command.

CR:440464

CR Number:   440464 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) 15.0.2 12 Jan 2007 Fixed Description The ASE-15_0/SC-3_0/log directory is created as an empty directory in the release area.

CR:440486

CR Number:   440486 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   SunOS Original Version:   15.0.1 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 29 Aug 2006 Fixed Description Stored procedure sp_datatype_info does not report correct 'create_params' information on nchar and nvarchar.

CR:440492

CR Number:   440492 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   all Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 30 Aug 2006 Fixed 14 Sep 2006 Fixed Description ASE Plug-in, through component 'dsparser.jar', was not able to process server entries in a interface file that has multiple 'query' services, or services with filters (e.g. 'ssl'). This has been fixed.

CR:440501

CR Number:   440501 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) 24 Oct 2006 Fixed 25 Oct 2006 Fixed Description SSL: isql sessions hang when doing a select query and the negotiated packet size is 4096 or greater.

CR:440567

CR Number:   440567 Product Name:   Adaptive Server Enterprise Product Component:   JVM Status:   Closed OS:   Solaris Original Version:   15.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 27 Aug 2006 Duplicate Description Fully support custom packages and classes from JVM 1.4.x

CR:440572

CR Number:   440572 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   Solaris Original Version:   15.0 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description expand xml capabilitiesin ASE 15 to do updates in addition to query

CR:440573

CR Number:   440573 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.1 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 26 Aug 2006 Fixed Description When a union view or union derived table is used within a correlated subquery and the correlation involves some join between the union projection and an expression, following compilation error could happen: Msg 403, Level 16, State 2 Invalid operator for datatype op: type: VARCHAR.

CR:440600

CR Number:   440600 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 May 2010 Fixed 20 May 2010 Fixed Description Feature Request: Add support for encrypting coumns of type Text/Image/Unitext

CR:440624

CR Number:   440624 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) 20 Sep 2006 Bundled Request Description When literal autoparameterization is on, SELECT with FOR BROWSE may fail with TDS error if there are literals in the where clause.

CR:440654

CR Number:   440654 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX Original Version:   To Be Determined Fixed Version Build Resolution Date Closure Code (If Appropriate) 09 May 2007 Insufficient priority to fix 08 May 2007 Insufficient priority to fix 22 May 2009 Fixed 06 Oct 2009 Added to user documentation Description Customer needs way to identify ASE spid in a network trace/TDS

CR:440757

CR Number:   440757 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.4 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Sep 2006 Fixed Description A new builtin switchprop() is added. Passing a switch-name or -number to the switchprop() builtin will return a status which contains the switch properties. Workaround Description  n/a

CR:440766

CR Number:   440766 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) 18 Dec 2006 Fixed 18 Jan 2007 Fixed 13 Feb 2007 Fixed 27 Feb 2007 Fixed Description A new stored procedure sp_helpapptrace has been added for application tracing feature. This procdure lists all the sessions that are being traced, the sessions tracing them and the names of the tracefile.

CR:440821

CR Number:   440821 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15 Aug 2008 Fixed Description Add to installmaster a new system stored procedure (sp_tab_suspectptn) to list table(s) with suspect partitioning.

CR:440832

CR Number:   440832 Product Name:   SySAM Product Component:   SAMreport Status:   Closed OS:   all Original Version:   3.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Dec 2011 EOL'd version. Not to be Fixed. Description Excessive character is included in Japanese of Japanese vertical line label of Summary Barchart Report.

CR:440855

CR Number:   440855 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.4 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 31 Aug 2006 Fixed 10 Oct 2006 Fixed Description Query using multiple worktables to resolve aggregates or provide distinctness or the order and performing dynamic index strategy to resolve OR predicate may fail with different errors related to sort operations including error 1509 "Internal error encountered in merging rows; resubmit query batch." Sometimes query execution may fail with stack trace logged in the errorlog. The module shown in the backtrace is bld_dynindex.

CR:440874

CR Number:   440874 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Digital UNIX Original Version:   12.5.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Nov 2006 Fixed 07 Nov 2006 Fixed Description When a spid is killed on the remote ASE, the local ASE may be infected with signal 11 in ksct_startio when accessing proxy table mapped to the remote ASE.

CR:440876

CR Number:   440876 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) 05 Sep 2006 Fixed Description sp_help and sp_helpartition show the row count as zero for proxy tables

CR:440880

CR Number:   440880 Product Name:   Adaptive Server Platform_Specific Docs Product Component:   Installation and Configuration Guide-ASE Status:   Closed OS:   HP-UX Original Version:   12.5.4 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 May 2007 Presently Not Targeted For Any Future Release Of This Product Description Documentation of Pre-Installation tasks for Adaptive Server Enterprise version 12.5.4 on HP Tru64 Unix is incorrect. The document needs to be updated to reflect the installation advice for Tru64 Unix.

CR:440923

CR Number:   440923 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   SunOS Original Version:   12.5.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.5.4 ESD#3 31 Aug 2006 Fixed 08 Sep 2006 One-off Provided 08 Sep 2006 One-off Provided 17 Oct 2006 Fixed Description The message "current process infected with 11 in the module sendtext()" together with a stacktrace which includes the modules 's_execute', 'exec_eop' and 'run' maybe reported in the errorlog when running a SELECT with a UNION ALL clause and ORDERBY selecting text or image columns from a table.

CR:440924

CR Number:   440924 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) 18 Aug 2008 Fixed 20 Aug 2008 Fixed Description ASE prints the User Connection Report at the 24hr interval irrespective of the license type.

CR:440932

CR Number:   440932 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) 07 Sep 2006 Fixed 13 Sep 2006 Fixed 12 Sep 2006 Fixed 12 Sep 2006 Fixed Description In rare circumstances, the message "current process infected with 10" in the module 'lddb__stat_translate' together with a stacktrace which includes the modules 'lddb__unscr_stat_page' and 'lddb__unscr_usro' may be reported in the errorlog when running LOAD DATABASE across platform where the endian type is different. Other errors, like 'Invalid column length' error, 1142, 692, or 12315 error may be reported. Workaround Description  Delete statistics on sysindexes before DUMP DATABASE by following command: 1> delete statistics sysindexes 2> go

CR:440969

CR Number:   440969 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) 12 Nov 2006 Fixed Description Adding a built-in password_admin for password administration related operations.

CR:441012

CR Number:   441012 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   SunOS Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 03 Sep 2006 Fixed 07 Sep 2006 Fixed 07 Sep 2006 Fixed Description Enable the input parameter column size used in a web service proxy table to be automatically generated based on the ASE page size. Workaround Description  *** Thursday, August 31, 2006 12:17:55 PM *** cooperg *** None. Attempted to modify sp_webservices to change 2048 values to some larger size but the column was always 2048.

CR:441015

CR Number:   441015 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) 17 Dec 2007 Not reproducible with latest version of the product available as of Resolution Date Description Feature request to enhance dbcc tablealloc / checkalloc to report and fix a condition that results in dbcc checkstorage fault 100016.

CR:441020

CR Number:   441020 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   Windows XP Original Version:   12.5.4 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Oct 2006 Fixed 09 Oct 2006 Fixed 12 Oct 2006 Fixed Description The minimum password length of system encryption password does not match the minimum password set in sp_configure. Workaround Description  Adaptive Server Enterprise/12.5.4/EBF 13731 ESD#1/P/Sun_svr4/OS 5.8/ase1254/2013/32-bit/FBO/Sat Jul 22 07:56:48 2006 Sybase Central ASE Plug-in/12.5.4/GA Build 1/S/1.4/ase1254dev/Sat Jul 22 09:31:39 PDT 2006 Setting the configuration option for 'minimum password length', both the old version in Server Configuration tab of Server Properties, and the new Login Password Configuration tab, should control the behavior of any dialogs for creating or changing passwords. There have been a few problems found and fixed for the dialogs for logins (e.g 422217). Now it is found that the dialogs for System Encryption Password have some similar problems. Repro Make sure "enable encrypted columns" is set to 1 in Server Configuration (restart server if you have to change it to get to 1) Scenario 1 1. Server Config value = 6, Login Password Config = OFF 2. Select menu option <database>/System Encryption Key/Create System Encryption Password 3. Message says "Password must be at least 6 characters long" 4. Enter password and confirm password 5. OK button not enabled until passwords match and are at least 6 characters. Scenario 2 1. Server Config value = 6, Login Password Config = 9 ( new option should override old option) 2. Select menu option <database>/System Encryption Key/Create System Encryption Password 3. Message says "Password must be at least 6 characters long" 4. Enter password and confirm password 5. OK button not enabled until passwords match and are at least 6 characters. Scenario 3 1. Server Config value = 9, Login Password Config = 9 ( new option should override old option) 2. Select menu option <database>/System Encryption Key/Create System Encryption Password 3. Message says "Password must be at least 6 characters long" 4. Enter password of 6 characters and confirm password 5. OK button is enabled when passwords match and are at least 6 characters. 6. A password of 6 characters gets an error message - password must be at least 9 characters Scenario 4 1. Server Config value = 4, Login Password Config = 9 ( new option should override old option) 2. Select menu option <database>/System Encryption Key/Create System Encryption Password 3. Message says "Password must be at least 6 characters long" 4. Enter password of 4 characters and confirm password 5. OK button not enabled since passwords are not at least 6 characters. 6. Go into isql and call sp_encryption system_encr_passwd, 'abcd' 7. password accepted The same things happen in the Alter System Encryption Password dialog. So it appears that there are a couple of problems 1. Whatever the option value is, the dialogs are not adjusting their message and text length requirements 2. Setting the Login Password Configuration option which should override the Server Config option, is not doing so.

CR:441029

CR Number:   441029 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.1 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 27 Sep 2006 Fixed 27 Sep 2006 Fixed Description In rare circumstances, server might not boot up reporting 'max repartition degree' > 'max parallel degree'. Workaround Description  workaround is to manually edit the configuration file and set "max repartition degree" to something <= "max parallel degree"

CR:441060

CR Number:   441060 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) 05 Sep 2006 Fixed Description Missing using a correlated predicate as a sarg underneath a subquery when the predicate involves an expression with correlated column(s). This could cause less performing plan.

CR:441070

CR Number:   441070 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 Sep 2006 Fixed 19 Sep 2006 Fixed 19 Sep 2006 Fixed 25 Sep 2006 Fixed Description A sort failure may occur while rebuilding clustered/placement index as part of AMC operation. This may lead to improper rollback of AMC operation (In our case, the partition rootpage is not rolled back properly). A wrongpage error (605/696) will be thrown upon subsequent access of the table

CR:441107

CR Number:   441107 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   12.5.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description AUDIT: Request for login audit records to include 'programe_name' and 'clientapplname' information in it's extra information field. Workaround Description  None known.