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

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

CR:564409

CR Number:   564409 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.3 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 24 Feb 2012 Deferred Description Feature request to make reorg compact and reorg forwarded_rows not take exclusive table lock when it finds forwarded rows. Workaround Description  // avoid forward rows.

CR:564420

CR Number:   564420 Product Name:   Adaptive Server Enterprise Product Component:   InstallShield Status:   Closed OS:   all Original Version:   15.0.3 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.0.3 ESD#2 26 Mar 2009 Duplicate 18 Mar 2009 Added to user documentation 19 Mar 2009 Fixed Description The default value of memory to allocate for Adaptive Server in the Out-of-the-box Configurator checks only physical memory, not available memory.

CR:564439

CR Number:   564439 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 28 Apr 2009 Fixed Description The message reported in the ASE server log when the sybpcidb database does not exist has been improved and now contains more information. The new message suggests that the sybpcidb database may be missing, or it may need to be initialized with the installpcidb script.

CR:564478

CR Number:   564478 Product Name:   Adaptive Server Enterprise Product Component:   MDA/Monitoring Tables Status:   Closed OS:   Solaris Original Version:   15.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15 Mar 2009 Duplicate Description Select on "monOpenObjectActivity" raises error 12035 when there is a DBName and ObjectName are greater than 30 characters each.

CR:564544

CR Number:   564544 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UNIX Original Version:   15.1 ESD #4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Apr 2009 Bundled Request 22 Mar 2009 Fixed Description Adaptive Server may raise an 893 error, "Fatal Error: Physical lock on <pageno>, <dbid> is being downgraded while the buffer is in dirty state. Please contact Sybase Technical Support." when it downgrades the physical lock on a buffer of a page that is not the last log page.

CR:564618

CR Number:   564618 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UX Original Version:   15.0.3 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 24 Jun 2009 Fixed 19 Jun 2009 Fixed 01 Sep 2009 Fixed Description The 'max memory' config parameter's default size is not enough to boot 16k server when pci is enabled on HP platform.

CR:564704

CR Number:   564704 Product Name:   ASE Management Product Component:   Web Console Status:   Closed OS:   Windows XP Pro Original Version:   3.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 22 Apr 2009 Fixed 26 Mar 2009 Added to user documentation 23 Apr 2009 Fixed 28 Apr 2009 Fixed 02 May 2009 Fixed 04 May 2009 Fixed Description If the tempdb database data or log segments on the monitored Adaptive Server become full the ASE Monitor displays incomplete data and the mouse cursor may remain in a busy state.

CR:564948

CR Number:   564948 Product Name:   Adaptive Server Enterprise Product Component:   InstallShield Status:   Closed OS:   Solaris Original Version:   15.0.2 ESD#6 Fixed Version Build Resolution Date Closure Code (If Appropriate) 08 Mar 2010 Presently Not Targeted For Any Future Release Of This Product Description Request for using tarball for EBF/ESD distribution.

CR:564990

CR Number:   564990 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX Original Version:   15.0.3 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 31 Mar 2009 Fixed 01 Apr 2009 Fixed 01 Apr 2009 Fixed 02 Apr 2009 Fixed 01 Apr 2009 Fixed 02 Apr 2009 Fixed 02 Apr 2009 Fixed 02 Apr 2009 Fixed Description The license agreement text cannot be loaded with the first geographic location during installation using GUI mode.

CR:565026

CR Number:   565026 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) 01 Apr 2009 Fixed Description Incorrect results could be returned when executing a query joining two or more tables having in its WHERE clause a comparison between two expressions which both result in a java object and the plan selected by the optimizer decided to use a reformatting mechanism. Workaround Description  Disable reformatting for the query: execute it with "set store_index 0"

CR:565071

CR Number:   565071 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Monitor table (MDA) that show service time for a device in ASE.

CR:565083

CR Number:   565083 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) 16 Apr 2009 Fixed 16 Apr 2009 Fixed Description The SySAM Administrator plugin only displays the last entry (count) in the license file for a consolidated license file

CR:565091

CR Number:   565091 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.2 ESD#6 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15 Apr 2009 Duplicate Description Signal 11 at CgLavaUtils::CgTargetListExprs may occur when running a query joining a local table with a proxy table after update statistics has been run on the proxy table.

CR:565165

CR Number:   565165 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   pyxis Fixed Version Build Resolution Date Closure Code (If Appropriate) 22 Mar 2009 Fixed Description For clusters with two or more instances, the message "timeslice error: spid" may be reported in errorlog for the module cmcc__getphysicallock.

CR:565267

CR Number:   565267 Product Name:   Adaptive Server Generic Docs Product Component:   Reference Manual:Building Blocks Status:   Closed OS:   all Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15 Feb 2012 Added to user documentation Description Document that in ASE the results of modulo have the same sign as the dividend.

CR:565272

CR Number:   565272 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   pyxis Fixed Version Build Resolution Date Closure Code (If Appropriate) 22 Mar 2009 Fixed 02 Apr 2009 Fixed Description On HP, Error " Internal Error in the IP Link Monitor cannot determine a link state based on returned error 22" may report in the error log and cause link monitoring and link switch failures.

CR:565273

CR Number:   565273 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.3 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Oct 2009 Fixed 14 Oct 2009 Fixed 18 Nov 2010 One-off Provided Description signal 11 could happen in ResRelOp() during codegen when a constant expression from a view or derived table is SELECTed from an outer join view inner side and the constant expression is further participating in a simple WHERE clause (comparison involving other constant only) when the outerjoin view is queried.

CR:565276

CR Number:   565276 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.3 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 24 Jun 2009 Fixed Description Under compatibility mode, traceflag 302 diagnostics might output "unnamed-col" for predicate printing instead of the real column name.

CR:565310

CR Number:   565310 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   aries Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 Jun 2009 Fixed 01 Jun 2009 Reservation Made Description New configuration option "FIPS login password encryption" is added. Its valid value is 0/1. Its default value is 0.

CR:565321

CR Number:   565321 Product Name:   Adaptive Server Enterprise Product Component:   MDA/Monitoring Tables Status:   Closed OS:   all Original Version:   pyxis Fixed Version Build Resolution Date Closure Code (If Appropriate) 28 Sep 2012 Fixed Description In parallel query mode, monProcessWorkerThread.ThreadsActive, monProcess.NumChildren, monSysWorkerThreads.PlansAltered and monProcessStatement.PlansAltered are always 0.

CR:565377

CR Number:   565377 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Windows Original Version:   15.0.3 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 06 May 2010 Fixed Description The tracefile generated on NT and viewed from notepad does not have carriage return and appears that the whole content is printed in a single line.

CR:565392

CR Number:   565392 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UNIX Original Version:   pyxis Fixed Version Build Resolution Date Closure Code (If Appropriate) 28 Apr 2009 Third Party Problem Description On HP-UX platform, RTDS does not support IBM MQ SSL feature, if IBM MQ version is lower than 6.0.2.6.

CR:565393

CR Number:   565393 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   Solaris Original Version:   15.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description We need a facility to force through an increase in the number of partition descriptors on busy systems.

CR:565409

CR Number:   565409 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plugin Status:   Closed OS:   all Original Version:   15.0.2 ESD#6 Fixed Version Build Resolution Date Closure Code (If Appropriate) 26 Mar 2009 Presently Not Targeted For Any Future Release Of This Product Description Sybase Central 15.0.2 ASE Plug-in doesn't start if you have connection profiles previously defined by 12.5.x ASE Plug-in. Remove "C:/Documents and Settings/<login>/.SCUserPreferences43" before upgrading to 15.0.2. to get around the issue. Workaround Description  edit the.scUserPreferences file and change value from true to false: ConnectionProfileData/SYBASEASE/Autostart=false After that, Sybase Central starts fine ! or delete CUSERPREFERENCES files it will generate a new on when it start. Also SybaseCentral 6 (15.0.3) works.

CR:565420

CR Number:   565420 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   aries Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 Aug 2009 Fixed 09 Jun 2009 Presently Not Targeted For Any Future Release Of This Product 26 Apr 2009 Fixed 04 Aug 2009 Fixed 18 Aug 2009 Fixed Description upgrade from 15x to ARIES SMP fails

CR:565464

CR Number:   565464 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 ALTER TABLE ADD column raises error 13918 if a function specified for the default rather than a literal value. The workaround is to use a literal value and then use ALTER TABLE REPLACE to replace the literal value default with a function default. Workaround Description  First use a literal value for the default, then modify the default to be the function: create table t (c1 int) go alter table t add c2 datetime default "1/1/1900" not null go alter table t replace c2 default getdate() go

CR:565467

CR Number:   565467 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   NA Original Version:   pyxis Fixed Version Build Resolution Date Closure Code (If Appropriate) 23 Mar 2009 Fixed Description sp_lock output shows negative spid ID for certain row locks

CR:565484

CR Number:   565484 Product Name:   Adaptive Server Enterprise Product Component:   sybmon Status:   Closed OS:   Solaris Original Version:   12.5.4 ESD#9 Fixed Version Build Resolution Date Closure Code (If Appropriate) 09 Apr 2009 Fixed 09 Apr 2009 Fixed 16 Apr 2009 Fixed Description Using a large value for 'max memory' and setting 'allocate max shared memory'=1 may cause the shared memory dump size to be much bigger than expected against SYBMON. Workaround Description  The bug was due to sybmon includes the unused memory in the memory dumps for some configurations. To reduce the memory dump size so that it's close to the estimated dump size in sp_shmdumpconfig output, we may modify the configuration file to set 'max memory' based on the value of sp_configure 'total logical memory'. Or Set 'allocate max shared memory'=0.

CR:565504

CR Number:   565504 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   pyxis Fixed Version Build Resolution Date Closure Code (If Appropriate) 22 Apr 2009 Fixed Description The rollback of a bulk insert operation on a table with TEXT columns may encounter a 3478 error. This situation may happen for UNITEXT, or TEXT columns in a multi-byte character set server.

CR:565507

CR Number:   565507 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   pyxis Fixed Version Build Resolution Date Closure Code (If Appropriate) 31 Mar 2009 Fixed 31 Mar 2009 Fixed Description The recovery redo pass suffers from reduced performance during server boot, cluster failover, LOAD DATABASE and LOAD TRAN, because asynchronous prefetch is incorrectly disabled.

CR:565508

CR Number:   565508 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   pyxis Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Apr 2009 Bundled Request Description The interrupt-based mechanism of acquiring the last log object lock by secondary BCM was not exercised.

CR:565566

CR Number:   565566 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   pyxis Fixed Version Build Resolution Date Closure Code (If Appropriate) 25 Mar 2009 Fixed Description The command "sp_cluster logical, failover, <logical cluster>, cluster, <to instance list>" ignores the user specified "to instance list" and fails over to a system selected set of instances.

CR:565585

CR Number:   565585 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UNIX Original Version:   pyxis Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Apr 2009 Bundled Request Description A task trying to acquire a physical lock on a page tried to access the last log page pointer from the dbtable field and hit a signal 11 error.

CR:565638

CR Number:   565638 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   pyxis Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Apr 2009 Fixed Description In an SDC environment with a large number of connections from different instances sharing the same database with concurrent DML operations, a hang can be observed where a thread in the module bufnewpage() is waiting for a buffer's MASS_DESTROY state to be reset.

CR:565647

CR Number:   565647 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   pyxis Fixed Version Build Resolution Date Closure Code (If Appropriate) 31 Mar 2009 Fixed 31 Mar 2009 Fixed Description On HP-UX a command that writes data to an encrypted column may fail with a 15429 error message, "An internal error occurred when Adaptive Server was generating random data during an encryption operation. Please contact Sybase Technical Support."

CR:565674

CR Number:   565674 Product Name:   Adaptive Server Enterprise Product Component:   DBISQL Status:   Closed OS:   all Original Version:   15.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 26 Mar 2009 Fixed Description DBISQL incorrectly showed Plan Viewer menu item when connected to 12.5.x ASE. Plan Viewer is only supported for 15.x ASE or later.

CR:565677

CR Number:   565677 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.0.2 ESD#6 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description wrong results: update with sum(col2) returning incorrect results, and no error MSSQL raises a 157 error when this occurs

CR:565687

CR Number:   565687 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   pyxis Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 Sep 2009 Fixed 05 Oct 2009 Fixed Description ASE Cluster Edition instances may hang in case of an irrecoverable error, for which shutdown was triggered automatically from within the ASE.

CR:565691

CR Number:   565691 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.2 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 08 Apr 2009 Not reproducible with latest version of the product available as of Resolution Date Description Error: 702 in memalloc when passed a bad column length.

CR:565728

CR Number:   565728 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   pyxis Fixed Version Build Resolution Date Closure Code (If Appropriate) 24 Mar 2009 Fixed 20 Apr 2009 Duplicate Description Sig11 or assertion failure may hit when one instance is writing the config file and the other instance is trying to read the config file as part of booting the joint instance.

CR:565732

CR Number:   565732 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.3 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 30 Mar 2009 Fixed Description SEGV occurs in ASE when accessing a proxy table and the remote server's connection is killed. Workaround Description  Use boot time trace flag 11297 (-T11297). This enables ctlib API checking and it catches the problem and avoids the server crash.

CR:565752

CR Number:   565752 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.2 ESD#6 Fixed Version Build Resolution Date Closure Code (If Appropriate) 25 Jun 2009 Fixed Description Add ability to kill process querying syslocks table.

CR:565828

CR Number:   565828 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 Mar 2009 Fixed Description The attempt to failover to secondary LDAP server may fail silently (without a message in the errorlog) if the secondary URL and secondary access account details are not configured correctly.

CR:565834

CR Number:   565834 Product Name:   Adaptive Server Enterprise Product Component:   DBISQL Status:   Closed OS:   all Original Version:   15.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 30 Mar 2009 Fixed 30 Apr 2009 Fixed 01 Apr 2009 Fixed 09 Apr 2009 Fixed 07 Apr 2009 Fixed 13 Apr 2009 Fixed 01 May 2009 Fixed Description The last two charaters of binary data are truncated in 'text' results mode.

CR:565849

CR Number:   565849 Product Name:   Adaptive Server Enterprise Product Component:   backup server Status:   Closed OS:   Linux Original Version:   12.5.4 ESD#8 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Aug 2009 Presently Not Targeted For Any Future Release Of This Product 20 Aug 2009 Presently Not Targeted For Any Future Release Of This Product 20 Aug 2009 Presently Not Targeted For Any Future Release Of This Product Description DUMP DATABASE/TRANSACTION with the COMPRESSION= syntax can be slower than using the COMPRESS:: syntax

CR:565850

CR Number:   565850 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   12.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Feature request to improve handling of level 0 scans by causing dba commands to block on them rather than fail with an error, and to reveal their existence through a new lock type entry in syslocks.

CR:565856

CR Number:   565856 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.3 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 31 Mar 2009 Fixed Description When upgrading 1254 server to 1503 ESD#2, error 12324 is raised while upgrade steps [3 alter table (table sysindexes)] is being executed.

CR:565862

CR Number:   565862 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) 24 Oct 2013 Fixed Description Increase granularity of GRANT / REVOKE permissions for SA_ROLE or SSO_ROLE.

CR:565864

CR Number:   565864 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Feature Request to include spid's listener IP and port in sysprocesses

CR:565865

CR Number:   565865 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central Plug-in Status:   Closed OS:   all Original Version:   15.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 Apr 2013 Fixed Description Feature request for a tool that would gather environment and diagnostic information typically needed by tech support. Workaround Description  Some diagnostic scripts [current as of March 2009) being developed by Chris McCartney are in /remote/cases/11516000s/11516704/pseinfo-11/Diagnostics

CR:565877

CR Number:   565877 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 03 May 2009 Fixed Description Message 14623 doesn't provide enough info for users to perform corresponding operations to continue downgrade. It should provide more infomation like which objid and indid the row has.

CR:565878

CR Number:   565878 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   AIX Original Version:   15.0.2 ESD#5 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Index is not used on tables in a view when view is joined in a query. Workaround Description  joins are not pushed down when aggregates are computed in the query. One workaround is to create a temp table without the aggregates, and then compute the aggregate on the temp table, but this would only help if number of rows in the worktable are relatively small.

CR:565938

CR Number:   565938 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   pyxis Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Apr 2009 Fixed Description Adptive Server may hang during failover recovery if all cluster instances had high transaction activity at the time of node crash.

CR:565943

CR Number:   565943 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   pyxis Fixed Version Build Resolution Date Closure Code (If Appropriate) 01 Apr 2009 Fixed Description 'optdiag simulate statistics' utility could fail in a cluster environment.

CR:565961

CR Number:   565961 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.3 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 26 Mar 2009 Fixed Description Execution of sp_configure to switch off the parameter 'procedure deferred compilation' may not complete leading to stack trace. Workaround Description  Use trace 7730 to switch off the deferred compilayion.

CR:565964

CR Number:   565964 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   pyxis Fixed Version Build Resolution Date Closure Code (If Appropriate) 07 Apr 2009 Fixed Description In rare circumstances, error message 14108, "Could not find partition descriptor for objid", may be reported in the errorlog while creating index on the table.

CR:566009

CR Number:   566009 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 Enhancement to RECOVERY_TIMEOUT functionality to distinguish between ASE online, production databases online and ignore irrelevant databases recovery rather than insisting that all databases recover within a certain time.

CR:566035

CR Number:   566035 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Allow auto-extend feature to use additional "default" devices.

CR:566055

CR Number:   566055 Product Name:   Adaptive Server Platform_Specific Docs Product Component:   Release Bulletin for Linux Status:   Closed OS:   NA Original Version:   12.5.4 ESD#9 Fixed Version Build Resolution Date Closure Code (If Appropriate) 28 Mar 2013 Fixed Description A description of the use of trace flags 1648 and 1649; to enable direct i/o and Linux KAIO should be included in the documentation for Release Bulletin Adaptive Server Enterprise 12.5.4 for Linux If you are running 12.5.4 ESD1 or later on Linux 2.6 kernel, you can enable direct i/o for all devices by booting with traceflag 1648. This should be used in conjunction with 1649 to enable native Linux kernel async i/o. Workaround Description  N/A

CR:566192

CR Number:   566192 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   pyxis Fixed Version Build Resolution Date Closure Code (If Appropriate) 03 Apr 2009 Fixed Description All the cache memory cannot be moved from default cache pool to a bigger pool as the default pool should have at least 512k or 25 buffers whichever is greater. However in ASE Cluster Edition this rule is broken when the cluster has more than single instance configured.

CR:566259

CR Number:   566259 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   Microsoft Windows Original Version:   15.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 27 Mar 2009 Bundled Request Description Server Discovery failed in ASE Plug-in and SySAM Plug-in.

CR:566329

CR Number:   566329 Product Name:   Adaptive Server Enterprise Product Component:   MDA/Monitoring Tables Status:   Open OS:   all Original Version:   15.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Feature request for future versions of ASE 15 to store more information about backups in the MDA tables to track :- - backup start/end time - datasize - raw and compressed (if compression used) - backup type

CR:566417

CR Number:   566417 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 Apr 2009 Fixed 09 Apr 2009 Fixed Description If the number of elements in the IN list is larger than 128 and the IN list has mixed data type elements, it could cause wrong results. Normally it returns less rows than expected. Workaround Description  Use traceflag 15393.

CR:566575

CR Number:   566575 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Windows XP Original Version:   15.0.3 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 01 Apr 2009 Fixed Description sp_version installmaster for 1503 ESD1 in NT platform won't get correct version info. As while building installmaster in NT platform, it won't generate the statement that could insert version info into sysattributes.

CR:566608

CR Number:   566608 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   12.5.4 ESD#7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 09 Nov 2009 DEFER 11 Nov 2009 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.

CR:566628

CR Number:   566628 Product Name:   Adaptive Server Enterprise Product Component:   diagserver Status:   Closed OS:   all Original Version:   15.0.3 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 04 May 2009 Fixed 04 May 2009 Fixed Description Under stressfull conditions, where concurrency between ASE Tasks and Commmercial Of The Shelf JavaVM Threads execute, both operating for PCI Bridge managed memory, they could potentially lockup because of a PCI Memory management flaw not yielding other ASE Tasks or Threads. This problem could finally lead to an ASE server crash under shutdown or full hang when in shutdown.

CR:566661

CR Number:   566661 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) 19 May 2009 Duplicate Description New feature requested to enable deferred compilation to be switched off at a session level. Workaround Description  N/A

CR:566676

CR Number:   566676 Product Name:   Adaptive Server Platform_Specific Docs Product Component:   Configuration Guide for UNIX Status:   Closed OS:   all Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 27 May 2009 Fixed Description docs: sysam users guide needs clarification on 3 srvr redundant configs

CR:566712

CR Number:   566712 Product Name:   Adaptive Server Enterprise Product Component:   backup server Status:   Open OS:   all Original Version:   15.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Feature request for an architectural change in backupserver that would allow more independence in the loading of dump stripes. Workaround Description  Dump to multiple stripes but only use one for loading.

CR:566767

CR Number:   566767 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   pyxis Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Apr 2009 Fixed Description A task trying to acquire a physical lock on a page exhausted the clock ticks beyond the allocated value and hit a timeslice error.

CR:566782

CR Number:   566782 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plugin Status:   Closed OS:   all Original Version:   15.0.3 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 31 Mar 2009 Fixed Description NullPointerException in Automatic Expension tab if ASE > 2K page server.

CR:566822

CR Number:   566822 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Msg 712 when try to handle a Big Xml file

CR:566882

CR Number:   566882 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   all Original Version:   15.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 27 Apr 2009 Fixed Description Modifying a segment's auto expansion attributes (grow-by or max-size) results in a syntax error.

CR:566926

CR Number:   566926 Product Name:   Adaptive Server Enterprise Product Component:   mscs_ha Status:   Closed OS:   Windows W2k Original Version:   12.5.4 ESD#9 Fixed Version Build Resolution Date Closure Code (If Appropriate) 07 Apr 2009 Presently Not Targeted For Any Future Release Of This Product Description Cluster Administrator cannot browse path of setup log on Windows Server 2003 with MSCS 5.2. An option is checked and cluster setup log is saved. In order to browse path of setup log in the following steps, when the "Browse..." button is clicked, Cluster Administrator will fail often.A Cluster Administratoe process will be extinguished.

CR:566981

CR Number:   566981 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.3 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 06 May 2009 Fixed Description Signal 11 in GtuUnion::GtSecondaryInit() may be seen in the error log and the spid terminated when selecting from a view containing a union all and the select includes > 1 variable assigment from the same column. Workaround Description  --in 15.0.3 ESD#1 or higher set compatibility_mode on

CR:566990

CR Number:   566990 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.2 ESD#6 Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 Jul 2009 Fixed 12 Feb 2010 Bundled Request Description sp_object_stats "00:01:00" does not produce output in version 15.0.x even if you have contention.

CR:566992

CR Number:   566992 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 01 Apr 2009 Duplicate Description There are 4 tables created by installmaster having ids > 100. The indexes on these tables are not automatically rebuilt when the sortorder id is changed. This results in corrupt indexes existing in the server.

CR:567039

CR Number:   567039 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) 08 Apr 2009 Fixed Description Upgrade to ASE 12.5.4 fails to add encryption-related tables and columns if the server has previously been downgraded from ASE 12.5.4 to ASE 12.5.3 or earlier versions. Workaround Description  Bring up ase1252 and enter following sql: sp_configure "allow updates",1 go delete from sysattributes where class = 1 and attribute > 1411 go sp_configure "allow updates",0 go Then reboot using the ase1254 server. Of course, always make certain to have a backup before starting.

CR:567056

CR Number:   567056 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Microsoft Windows Original Version:   15.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 08 Apr 2009 Fixed 08 Apr 2009 Fixed 08 Apr 2009 Fixed Description Japanese, Korean and Chinese localized files for HA support on Windows platform (sybcaeja.dll, sybcaeko.dll, sybcaezh.dll) are missing in ASE 15.0.3 release.

CR:567093

CR Number:   567093 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   Linux Original Version:   15.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description New feature request to estimate the log space needed to perform reorg rebuild on a table.

CR:567117

CR Number:   567117 Product Name:   Adaptive Server Generic Docs Product Component:   Reference Manual:Procedures Status:   Closed OS:   all Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 24 Apr 2012 Added to user documentation Description DOC CR : The behavior of sp_rename has been changed. If you change the name of an object referenced by a stored procedure or view, the procedure or view will not work any more.

CR:567187

CR Number:   567187 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   12.5.4 ESD#9 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Request for two new variables to enable the current setting of rowcount and forceplan, as set by the statements: set rowcount n and set forceplan on/off Workaround Description  N/A

CR:567201

CR Number:   567201 Product Name:   Adaptive Server Enterprise Product Component:   Job Scheduler Status:   Closed OS:   all Original Version:   15.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 24 Mar 2013 Duplicate Description Request for a verbose mode for sp_js_wakeup that would provide more information about failure to start JS, currently available via traceflag 3641

CR:567239

CR Number:   567239 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) 14 Apr 2009 Fixed 22 Apr 2009 Fixed Description Due to an issue with underlying dbcc checktable, sp_post_xpload can not detect all kind of index corruption, such as first key of one non-leaf page is bad. The new 'force' option of sp_post_xpload will force rebuild all the index except APL clustered index.

CR:567257

CR Number:   567257 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   pyxis Fixed Version Build Resolution Date Closure Code (If Appropriate) 09 Apr 2009 Fixed Description A deadlock may be incorrectly reported when there are many transactions holding shared lock on one object and waiting to acquire lock on another remote object. This is due to limitations in the deadlock detection algorithm. Optimization has now been added so that the algorithm will continue with deadlock detection if tasks holding shared lock are waiting on less than 9 distinct remote objects.

CR:567316

CR Number:   567316 Product Name:   Adaptive Server Enterprise Product Component:   xpserver Status:   Open OS:   Microsoft Windows Original Version:   15.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description xp_cmdshell on windows fail to execute the windows prompt command copy when this use options /B /Z and the file have a size of ZZZ MB.

CR:567317

CR Number:   567317 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.2 ESD#6 Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Apr 2009 Fixed 10 Apr 2009 Reservation Made 15 Apr 2009 Fixed Description DISTINCT query in 12.5 uses EXISTS table (i.e. semi-join), 15.0.x does not use a semi-join, which results in poor performance. A semi join can be used for tables in DISTINCT queries which are not referenced in the SELECT list Workaround Description  rewrite the query into an EXISTS query for those tables which are not in referenced in the SELECT list

CR:567325

CR Number:   567325 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.3 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 09 Apr 2009 Fixed 27 Apr 2009 Not a Bug 20 Jul 2009 Fixed 02 Aug 2009 One-off Provided 20 Sep 2009 Fixed 20 Sep 2009 Fixed Description FAST BCP path into table with numeric non-clustered index (available in 15.0.2 and higher) may result in index corruption Workaround Description  sp_dboption '<db>','select into', false

CR:567355

CR Number:   567355 Product Name:   Adaptive Server Enterprise Product Component:   DDLGen Status:   Closed OS:   all Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 07 Apr 2009 Fixed Description DDLGen generates an incorrect "go" between the two ENDs for dropping the primary key and the foreign key.

CR:567454

CR Number:   567454 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Feature request for a resource governor enhancement that would allow databases to be bound to engine groups, i.e. cause activity involving just that database migrate to a specified engine group.

CR:567466

CR Number:   567466 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 22 Apr 2009 Fixed 16 Feb 2010 Fixed Description When statement cache is turned on, if an exception occurs while compiling a statement which has temporary tables in it, an error msg 8203 could be raised. Workaround Description  The workaround for this is: 1. use command line traceflag 467: If TF 467 is on, statements referencing temp tables will not be cached. 2. use command line traceflag 299: This only work if there is already a successfully compiled plan in cache.

CR:567477

CR Number:   567477 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.3 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Apr 2009 Fixed 22 Apr 2009 Fixed Description SQL statements whose lengths are larger than 1K (measured in characters) that are replicated using SQL Statement Replication may cause Rep Agent to shutdown with error 9202, State 1 when attempting to process log records related to SQL Statement Replication. Workaround Description  Turn SQL Statement Replication off.

CR:567497

CR Number:   567497 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.1.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 06 Jul 2009 Duplicate Description In rare cases, where there are huge number of parallel page allocations for the same object, we might hit the 1127 error which means that the OAM pages of the object got full. Workaround Description  If a command hits this error, re-running the command should help

CR:567517

CR Number:   567517 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   pyxis Fixed Version Build Resolution Date Closure Code (If Appropriate) 04 May 2009 Fixed Description (Internal Only) dbcc checkalloc may fail with errors because of faulty post commit processing at failover recovery if the database is dropped and recreated between two failover recoverys.

CR:567577

CR Number:   567577 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 Apr 2009 Fixed 04 May 2009 Fixed Description Wrong result with a merge join or (if involving proxy table) signal 11 in CgLavaUtils::CgTargetListExprs() might happen for query with an equi-predicate on two columns of the same index. Workaround Description  set merge_join off --for the session plan '(use merge_join off)' --for the query

CR:567656

CR Number:   567656 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   RH Linux Original Version:   12.5.4 ESD#9 Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 Aug 2009 Fixed 21 Aug 2009 Fixed 28 Aug 2009 Fixed Description The Monitor Server can hang on the ibmplinux redhat 5.1 platform. Workaround Description  kill the hung monintor server process, and then restart monintor server.

CR:567757

CR Number:   567757 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   pyxis Fixed Version Build Resolution Date Closure Code (If Appropriate) 08 Apr 2009 Fixed Description Allow one master device to be paired with multiple quorum devices using the --create-cluster-id=quorum boot option. Pairing a master with multiple quorums is dangerous and should be avoided in most cases.

CR:567766

CR Number:   567766 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   To Be Determined Fixed Version Build Resolution Date Closure Code (If Appropriate) 23 Jul 2009 Fixed 19 May 2009 Fixed 03 Jun 2009 Fixed Description RepAgent may send an incomplete multi-byte character in text data to Replication Server when the text data is longer than 4KB and starts with an XML declaration element and contains multi-byte characters.

CR:567782

CR Number:   567782 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.2 ESD#6 Fixed Version Build Resolution Date Closure Code (If Appropriate) 29 Apr 2009 Fixed 29 Apr 2009 Fixed 04 May 2009 Fixed Description With Literal Autoparam and Statement Cache enabled, using a query with an IN list having numerics with a scale different from the scale defined on the column causes poor performance. Workaround Description  For this specific query, turn off the 'literal autoparam'. For exampel: set literal_autoparam off go run the this query set literal_autoparam on go Or Change the data to use int as the column definition is numeric(18,0).

CR:567787

CR Number:   567787 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.3 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Jul 2009 Fixed 17 Jul 2009 One-off Provided Description When statement cache and literal autoparam are enabled, a batch that contains \r\n (CR NL) sequence in the middle of two statements, the statement that right after \r\n sequence may not get correctly parameterized, offset may be shifted 2 bytes on the left. Workaround Description  Disable literal autoparam