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

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

CR:585188

CR Number:   585188 Product Name:   Adaptive Server Enterprise Product Component:   backup server Status:   Closed OS:   all Original Version:   15.0.3 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 26 Jul 2010 Insufficient priority to fix 16 Sep 2010 Fixed Description AT_ISSTRIPELDED returned -1 Error messages for backupserver should be improved

CR:585221

CR Number:   585221 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.2 ESD#5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 29 Oct 2009 Fixed Description In rare circumstances, the message "current process infected with 11" in the module 'des_rekeep' together with a stack trace which includes the modules 'proc__linktopss' and 'lwp_proc_setup' may be reported in the error log when a client application is executing a query using "dynamic sql" and the system is configured with a low value for the configuration parameter "number of open objects" according to its workload. Workaround Description  Increase the configuration value for "number of open objects" according to your system workload so the DEScriptors for the internal LWPs used by dynamic SQL are not reused.

CR:585260

CR Number:   585260 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) 20 Aug 2009 Fixed Description Unnecessary recompilations may happen if 'open by name' trace flag 299 is activated and a temporary table has at least one BIT column.

CR:585267

CR Number:   585267 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) 16 Mar 2012 Presently Not Targeted For Any Future Release Of This Product Description Derived table without specifying column name in the embedded select doesn't work Workaround Description  Specify the column name in the embedded select will work, eg, 1> select max(prevdate) from ( 2> select prevdate=dateadd(dd ,datediff(dd, '0:0', getdate()) - number ,'0:0') - column name here 3> from master.dbo.spt_values 4> where type='P' and number between 1 and 10 5> )t -- no column name here 6> where datepart(dw,prevdate) not in (1,7) 7> and not exists 8> (select 1 from holidays where holiday=t.prevdate) 9> go -------------------------- Aug 11 2009 12:00AM ==> it works

CR:585304

CR Number:   585304 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 29 Sep 2009 Fixed 11 Aug 2010 Fixed 12 Aug 2010 Fixed Description Parallel BCPs into a semantically partitioned DOL table can deadlock when two sessions perform allocation at the same time. The deadlock information will consistently show the deadlock ccurring on rowid 0 for both spids.

CR:585313

CR Number:   585313 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) 14 Aug 2009 Duplicate Description Create proxy_table fails when ECDA backend table has default values specified. Workaround Description  WorkAround: -------------- You can set the Access Service property to CSPColumnODBCVersion = 2, but no default values will be defined and you won't be able to take advantage of inserting data with use of default values. Can be a data integrity issue or cause errors. However you can do create existing table: [This done on MSSQL Server] sp_addobjectdef deftest_mssql_ce, 'dca150_mssql_win...deftest' go create existing table deftest_mssql_ce ( c1 int not null, c2 char(3) not null, c3 char(3) default 'abc' not null, c4 int default 0 not null ) go insert deftest_mssql_ce (c1, c2) values (1, 'zzz') go 1> select * from deftest_mssql_ce 2> go c1 c2 c3 c4 ----------- --- --- ----------- 1 zzz abc 0 (1 row affected) OR sp_addobjectdef deftest2_mssql_ce, 'dca150_mssql_win...deftest2' go create existing table deftest2_mssql_ce ( c1 int not null, c2 char(3) default 'abc' not null, c3 int ) insert deftest2_mssql_ce (c1, c3) values (1, 2) go 1> select * from deftest2_mssql_ce 2> go c1 c2 c3 ----------- --- ----------- 1 abc 2 (1 row affected)

CR:585444

CR Number:   585444 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) 19 Aug 2009 Fixed Description This introduces "ULC flushes by Log Markers" entry in the ASE sp_sysmon report. A high value for by Log markers indicates that Adaptive Server is flushing the ULCs because of permanent log marker scans (a permanent log marker scan indicate that syslogs includes the log record). Adaptive Server uses the log records for operations like executing triggers, rollbacks, aborts, and so on. When Adaptive Server needs a permanent log marker but does not have one, it flushes the ULC to create a new log marker. When by Log markers displays a large percentage of ULC flushes, you may need to reduce the number of unnecessary or redundant triggers, rollbacks, or aborts.

CR:585467

CR Number:   585467 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) 23 Aug 2009 Fixed Description Despite traceflag 11906 being on, reorg rebuild messages are reported to the errorlog.

CR:585474

CR Number:   585474 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) 16 Nov 2009 Fixed Description When using a dblib client version <5.0 that doesn't permit numerics, selecting on a bigint column creates a tds stream error. Workaround Description  WorkAround: ----------------- Issuing a convert (numeric(20), column) will not crash - but customer is refusing the workaround. Also (dbsetversion(DBVERSION_100) will work as well - again, customer refuses to do this. Their application also works with MSSQL Server, so they are used to using older TDS 4.X level. DBVERSION_100 will use newer TDS and this won't work on their MSSQL Server. When used, the data type is TDS_NUMN, Precision = 20 (0x14). Basically the CR is to fix the TDS bug.

CR:585485

CR Number:   585485 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   aries Fixed Version Build Resolution Date Closure Code (If Appropriate) 28 Aug 2009 Fixed Description Performance of bcp for SMP server is degraded.

CR:585517

CR Number:   585517 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) 03 Sep 2009 Fixed 04 Sep 2009 Fixed 22 Sep 2009 Fixed Description When a user with sa_role executes SETUSER to a non-sa_role user, creates a table and a procedure referring to that table, then execution of that procedure following a schema change such as dropping and recreating the table will result in an "object not found" error (Msg 208).

CR:585588

CR Number:   585588 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX Original Version:   15.0.2 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16 Nov 2009 Fixed 10 Nov 2009 Reservation Made Description When a disjunctive predicate that is same as a row constructor is used in a query, the optimizer will not chose a general OR strategy (also know as index union) will not be selected. The row constructor type predicate will have to look as follows (col1 > <literal1) OR (col1 = literal1 AND col2 GT/GE literal2). Workaround Description  This problem can be worked around by either explicitly parameterizing the query with variables or implicitly using autoparams. This can be done by simply parameterizing the query as follows: declare @v int declare @v1 int declare @v2 int select ... from A where a1 > @v or (a1 = @v1 and a2 >= @v2) Now the predicate transformation will not happen. This can be achieved also by literal parameterization and this is what we suggested.

CR:585665

CR Number:   585665 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) 17 Sep 2009 Fixed 14 Sep 2009 Fixed 17 Sep 2009 Fixed 21 Sep 2009 Fixed Description User applications that use JDBC or Java Stream operations may be affected by memory corruptions or abnormal process termination when the optimized ASE binary is in use. This problem is most likely to manifest on Linux 64-bit architectures.

CR:585707

CR Number:   585707 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.0.3 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Sub-optimal plan may be seen under allrows_oltp for query involving distinct multi-table join. Workaround Description  set conserve_tempdb_space 1 --or set opportunistic_distinct_view 0 Also, tracecommand line 15332 is available as a workaround with the changes in cr 598541.

CR:585711

CR Number:   585711 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.0.3 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Change in query plan maybe be seen between 'select' and select into' (or insert..select) for queries involving distinct multi-table joins. Workaround Description  set conserve_tempdb_space 1 --or set opportunistic_distinct_view 0 Also, tracecommand line 15332 is available as a workaround with the changes in cr 598541 in 15.0.3 esd #4 and above.

CR:585772

CR Number:   585772 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   aries Fixed Version Build Resolution Date Closure Code (If Appropriate) 27 Aug 2009 Fixed Description Internal only: stress tests with competing bcp and transfer-table tasks can cause the transfer to encounter a transitory wrong-page error from an uninitialized page.

CR:585798

CR Number:   585798 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) 21 Aug 2009 Bundled Request Description BCP Wizard's output shows the connection's password, which should be hidden. Also, BCP Wizard should not open if the server name is not in the interfaces file for BCP utility.

CR:585991

CR Number:   585991 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 Aug 2009 Fixed Description The SET SWITCH command does not work with traceflags 7714 and 7715.

CR:586032

CR Number:   586032 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.0.3 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 Feb 2010 Fixed Description If there is /tmp/locales directory and install ASE 15.0.3 ESD#1 into /tmp/ase1503 directory, srvbuil and srvbuildres does not work with error "unable to load localization file /tmp/locales/unicode/us_engli/srvconfig.lcu".

CR:586084

CR Number:   586084 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) 16 Sep 2013 Insufficient priority to fix Description Feature request to see the detailed information of HA sessions.

CR:586167

CR Number:   586167 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) 15 Sep 2009 Fixed 24 Sep 2009 Fixed 17 Sep 2009 Fixed 17 Sep 2009 Fixed Description Automatic workspace expansion in checkstorage does not expand the text workspace automatically even though the text workspace is smaller than the recommended size, which is 25% the size of the scan workspace.

CR:586220

CR Number:   586220 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.2 ESD#5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 27 Aug 2009 Fixed 28 Aug 2009 Fixed 16 Sep 2009 Fixed 04 Sep 2009 Fixed Description The error msg 414 could be raised if the plan chose reformatting strategy and it has many join predicates. Workaround Description  change the ase server from using 2K pages to using 4K pages...this was an unacceptable workaround for this customer ... JPMorgan (zhao 8/25/2009) The workaround could be turn off reformatting before this update query and turn on reformatting after this query. "set store_index 0" could be used to turn off reformatting strategy and "set store_index 1" used to tuen on reformatting.

CR:586356

CR Number:   586356 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.3 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 Aug 2009 Fixed Description For queries containing IN/OR list where one or more elements in the IN/OR list is a built-in function, unexpected results might be returned. Workaround Description  Avoid str_replace in the in clause declare @a varchar(17), @b varchar(17) select @a = 'FB-102195' select @b = str_replace(@a, "-", " ") select * from tempdb..tabA where ColA in (@a, @b)

CR:586387

CR Number:   586387 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.4 ESD#9 Fixed Version Build Resolution Date Closure Code (If Appropriate) 24 Jun 2010 Fixed Description Mistype the SIZE option of a DISK RESIZE command as 'SIDE' gives an error relating to DISK UNMIRROR instead of DISK RESIZE.

CR:586425

CR Number:   586425 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   Solaris Original Version:   15.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 24 Aug 2009 Fixed 25 Aug 2009 Fixed Description When running on a Unix system, the BCP Wizard cannot BCP in/out multiple tables.

CR:586426

CR Number:   586426 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   aries Fixed Version Build Resolution Date Closure Code (If Appropriate) 27 Aug 2009 Fixed 27 May 2014 Presently Not Targeted For Any Future Release Of This Product 31 Aug 2009 Fixed Description sp_dropdevice does not delete the physical file created for filesystem device

CR:586499

CR Number:   586499 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   aries Fixed Version Build Resolution Date Closure Code (If Appropriate) 23 Aug 2010 Fixed 05 Aug 2010 Reservation Made 24 Aug 2010 Fixed 16 Sep 2010 Fixed 09 Nov 2010 One-off Provided 13 Jan 2011 Fixed Description On Solaris platform, ASE may report "Unexpected AIO error(Invalid argument)returned from aiowait()." when LDAP User Authentication is enabled (configuration option 'enable ldap user auth' is set to 1 or 2) and ASE is performing multiple user authentication simultaneously. This bug can be resolved by installing patch for Solaris BugID 6972029 (contact Oracle for the OS patch, sun sparc: 144190-03, sun x64 144191-02). Alternatively, it can be resolved in ASE through a workaround fix by enabling boot time trace flag 9415. Workaround Description  Install patch for Solaris BugID 6972029 (contact Oracle for the OS patch).

CR:586565

CR Number:   586565 Product Name:   Adaptive Server Enterprise Product Component:   backup server Status:   Closed OS:   all Original Version:   15.0.3 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Aug 2009 Fixed 31 Aug 2009 Fixed 23 Sep 2009 One-off Provided 01 Dec 2009 One-off Provided 29 Aug 2012 Fixed Description A Dump or Load operation failing to open the device may not report the underlying Operating System error.

CR:586638

CR Number:   586638 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plugin Status:   Open OS:   all Original Version:   15.0.3 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Need to document how to use password encryption with Sybase Central

CR:586640

CR Number:   586640 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   Windows XP Original Version:   aries Fixed Version Build Resolution Date Closure Code (If Appropriate) 03 Sep 2009 Fixed Description SpinBox value get truncated when value greater than max.

CR:586666

CR Number:   586666 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   aries Fixed Version Build Resolution Date Closure Code (If Appropriate) 24 Aug 2009 Fixed 25 Aug 2009 Fixed Description Internal only: running 'transfer table' on a multi-engine server can fail with OS reported I/O errors.

CR:586727

CR Number:   586727 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   pyxis Fixed Version Build Resolution Date Closure Code (If Appropriate) 26 Aug 2009 Fixed 28 Oct 2009 One-off Provided Description Under certain circumstance, during recovery, timeslice may be hit while server is processing multiple lock related messages

CR:586748

CR Number:   586748 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   aries Fixed Version Build Resolution Date Closure Code (If Appropriate) 09 Sep 2009 Fixed Description In case of a mixed log and data database, a deadlock involving cm__waitfor_io() may be reported during boot recovery.

CR:586779

CR Number:   586779 Product Name:   Adaptive Server Enterprise Product Component:   backup server Status:   Closed OS:   all Original Version:   15.0.3 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 24 Aug 2009 Fixed 27 Aug 2009 Fixed 06 Jan 2010 EOL'd version. Not to be Fixed. Description The dump command may not raise an error message reporting "No space left on device" on Linux when the device is closed using Backup API compress.

CR:586809

CR Number:   586809 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   aries Fixed Version Build Resolution Date Closure Code (If Appropriate) 27 Aug 2009 Fixed Description "max transfer history" in DTU is missing after upgrade from 15.0 to 15.5 (Aries)

CR:586833

CR Number:   586833 Product Name:   Adaptive Server Enterprise Product Component:   DBISQL Status:   Closed OS:   all Original Version:   15.0.3 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 Dec 2009 Fixed 28 Feb 2010 Fixed 19 Jan 2010 Fixed 21 Dec 2009 Fixed 25 Jan 2010 Fixed 28 Jan 2010 Fixed Description DBISQL does not support password encryption directly.

CR:586861

CR Number:   586861 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) 22 Feb 2010 Fixed 05 Mar 2010 Fixed Description Query with CASE expression returning TEXT columns and TEXT constant may fail to execute correctly producing stack traces.

CR:587115

CR Number:   587115 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   aries Fixed Version Build Resolution Date Closure Code (If Appropriate) 01 Sep 2009 Fixed Description The kerberos principal name in the audit table is not being displayed.

CR:587182

CR Number:   587182 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   aries Fixed Version Build Resolution Date Closure Code (If Appropriate) 01 Sep 2009 Fixed 09 Sep 2009 Fixed Description Advisory messages printed by sp_dboption when trunc. log on chkpt. is turned on/off are confusing because they appear to be errors. The messages will no longer be printed by sp_dboption.

CR:587220

CR Number:   587220 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) 28 Aug 2009 Fixed 01 Sep 2009 Fixed Description The error 3146 will be raised when trying to load a database from a valid server version onto a database after having loaded a previous version onto the same database without having set the database online. Workaround Description  Drop and recreate the database.

CR:587274

CR Number:   587274 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   aries Fixed Version Build Resolution Date Closure Code (If Appropriate) 01 Sep 2009 Fixed Description In rare cases, a process might hit 706 error with stack trace including functions such as rm_prochdr and rec__ctx_cleanup.

CR:587362

CR Number:   587362 Product Name:   Adaptive Server Enterprise Product Component:   diagserver Status:   Closed OS:   all Original Version:   12.5.4 ESD#10 Fixed Version Build Resolution Date Closure Code (If Appropriate) 10 Sep 2009 Not a Bug Description If an application made use of a global temporary table in an external environment via a server-side connection, then there was a chance that the server may have given an assertion, hang or crash when the application connection closed. This problem has now been fixed.

CR:587403

CR Number:   587403 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) 24 Jun 2010 Bundled Request Description When raised by the DISK MIRROR command, error 5101 may incorrectly state that the command being run was DISK UNMIRROR.

CR:587406

CR Number:   587406 Product Name:   Adaptive Server Enterprise Product Component:   optdiag Status:   Closed OS:   all Original Version:   15.0.3 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 Nov 2009 Fixed Description In specific circumstance, error 511 may occur during optdiag input mode when creating column histograms. Workaround Description  Remove the relevant column statistics from the input file and perform the optdiag input. Create the stats on the target server manually using update statistics <table> (<column>)

CR:587426

CR Number:   587426 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   aries Fixed Version Build Resolution Date Closure Code (If Appropriate) 28 Aug 2009 Fixed Description Specifying a filename of 256 characters for DTU output file results in the correct error with right file name.

CR:587437

CR Number:   587437 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   One-off Fixed Version Build Resolution Date Closure Code (If Appropriate) 07 Sep 2009 Fixed 17 Sep 2009 Fixed 02 Dec 2009 One-off Provided Description When using parallel sort on worktable, errors and/or stack traces can be encountered while executing the sort operator. Workaround Description  Turn off parallel and set 'max parallel degree' to default value (1). This workaround may be not acceptable for some customers who need to use parallel for performance.

CR:587442

CR Number:   587442 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) 23 Sep 2009 Fixed Description Error 1265 when cursor fetch rows from syscomments table.

CR:587525

CR Number:   587525 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX 5.1 Original Version:   aries Fixed Version Build Resolution Date Closure Code (If Appropriate) 01 Sep 2009 Fixed Description set tracefile for spid will fail on ibmplinux platform with error 3659 "The spid 0 does not exist." even when the spid in the command is valid.

CR:587661

CR Number:   587661 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   Linux Original Version:   15.0.3 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description max locked memory should be increased with a call to setrlimit from dataserver processes for linux platforms.

CR:587742

CR Number:   587742 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   all Original Version:   aries Fixed Version Build Resolution Date Closure Code (If Appropriate) 04 Sep 2009 Fixed 15 Jan 2010 Fixed Description ASEPlugin 15.0.3 - NullPointerException error if SSL check box is checked.

CR:587810

CR Number:   587810 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.0.3 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 29 Aug 2012 Duplicate Description Add a configuration option 'enable HugePages' to control allocation as follows, with HugePages if available else regular pages, only with HugePages and fail if not available, only with Regular Pages.

CR:587877

CR Number:   587877 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 ASE may raise the misleading error message "The configuration area in device 'master' appears to be corrupt. The server cannot continue and will shut down." following an upgrade if the master device size is than the minimum for the new version.

CR:587879

CR Number:   587879 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 Mar 2012 Fixed Description preupgrade does not raise an error if the master device is too small and will pass the test, then while booting up the higher version server to apply upgrade, ASE will raise 110272 error.

CR:587984

CR Number:   587984 Product Name:   Adaptive Server Enterprise Product Component:   sybmigrate Status:   Closed OS:   Solaris Original Version:   15.0.3 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 30 Oct 2009 Duplicate Description sybmigrate may raise a 17741 error and fails to create a foreign key if multiple tables have complex logical relationship (a primary key and foreign keys) with each other. Workaround Description  Create a foreign key by yourself.

CR:588137

CR Number:   588137 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   pyxis Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 Jan 2010 Fixed 19 Jan 2010 Duplicate 14 Nov 2012 Fixed Description Duplicate key values could be generated for identity column during checkpoint of the database. For tables with unique indexes on identity column, it would give error 2601 'Attempt to insert duplicate key row in object <obj_name> with unique index <index_name>'. more co A more complete version of this fix has been developeed under CR 614823, i.e. 614823 supersedes 588137.

CR:588150

CR Number:   588150 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   aries Fixed Version Build Resolution Date Closure Code (If Appropriate) 03 Sep 2009 Fixed 17 Sep 2009 Added to user documentation Description Add InstanceID column to the below tables monInMemoryStorage monPCISlots monPCIEngine monPCIBridge monProcedureCacheModuleUsage monProcedureCacheMemoryUsage

CR:588162

CR Number:   588162 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   aries Fixed Version Build Resolution Date Closure Code (If Appropriate) 05 Sep 2009 Fixed Description For in-memory storage cache, if the memory allocated is less than user's requested cache size, cache creation will be failed.

CR:588176

CR Number:   588176 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plugin Status:   Closed OS:   SunOS Original Version:   aries Fixed Version Build Resolution Date Closure Code (If Appropriate) 01 Sep 2009 Not a Bug Description 15.0.3 or later ASE Plug-in is not compatible with Sybase Central 4.3.

CR:588214

CR Number:   588214 Product Name:   Adaptive Server Enterprise Product Component:   diagserver Status:   Closed OS:   all Original Version:   15.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Mar 2010 Fixed 01 Jun 2010 Presently Not Targeted For Any Future Release Of This Product 11 Mar 2010 Fixed Description Under rare circumstances when an ASE task disconnects due to connection loss the Java associated thread executing on the behalf of the ASE task will not be notified to clean up its resources. This will result in leaking thread and memory resources at operating system level.

CR:588263

CR Number:   588263 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Unknown Original Version:   aries Fixed Version Build Resolution Date Closure Code (If Appropriate) 29 Sep 2009 Fixed Description In rare circumstances we may hit error 8211 (Mismatch found between the name and id descriptor hash table for table) while accesing table in the multinode cluster environment.

CR:588268

CR Number:   588268 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   Solaris Original Version:   15.0.3 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Provide a command to enables the ASE sysam heart beat process to be restarted in the event that this process has stopped for any reason. Workaround Description  The feature has been requested because the workaround suggested on CR 498534 is not acceptable to the client.

CR:588272

CR Number:   588272 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   aries Fixed Version Build Resolution Date Closure Code (If Appropriate) 28 Jan 2010 Fixed Description When the ASE Replication Agent connects to the Replication Server version 15.5 or above, it will issue the Replication Command Language command 'resetqueue' by default when starting up against a database with a durability value of 'no_recovery', instead of incrementing the primary database generation ID, so to prevent the likelihood of hitting a limit while updating the generation ID value. The current ASE fix will be effective when the Replication Server CR 615322 is also released in some later Replication Server 15.5 ESD version. Workaround Description  N/A.

CR:588288

CR Number:   588288 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.0.3 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description New Feature ... exclude rs dsi thread from being deadlock victim in replicate db refer to ASE CR 230301 and refer to RepServer CR 370359 ... customer wants a feature request added where the RS thread is never the deadlock victim on a replicate db. He's had issues in the past where even after multiple retries, the tran is still in a deadlock causing the DSI to suspend. If the rs thread is chosen for the deadlock victim, in some cases even after attempting the tran multiple times it still deadlocks, causing the tran to not complete and the DSI to suspend or if set to ignore the primary and replicate dbs become out of sync

CR:588307

CR Number:   588307 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   Linux Original Version:   aries Fixed Version Build Resolution Date Closure Code (If Appropriate) 03 Sep 2009 Fixed Description To request high-availability when connecting to a cluster, put the following property on Connect Dialog's Advanced tab: REQUEST_HA_SESSION=true

CR:588310

CR Number:   588310 Product Name:   Adaptive Server Enterprise Product Component:   MDA/Monitoring Tables Status:   Closed OS:   all Original Version:   aries Fixed Version Build Resolution Date Closure Code (If Appropriate) 09 Sep 2009 Fixed Description Instance ID, transfer format (e.g., BCP, etc) are added to monTableTransfer

CR:588334

CR Number:   588334 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   Windows XP Original Version:   aries Fixed Version Build Resolution Date Closure Code (If Appropriate) 03 Sep 2009 Fixed Description User sees 'stop pv tracing' msg on preview dialog if user calls scheduler from preview dialog and calls cancel scheduler.

CR:588358

CR Number:   588358 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) 11 Mar 2010 Fixed Description Executing installhasvss script raises a 2615 error.

CR:588464

CR Number:   588464 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) 17 Sep 2009 Fixed 22 Sep 2009 Fixed Description Sometimes, database upgrade fails with error 1204, "out of lock error" while upgrading a system table with a huge number of rows.

CR:588556

CR Number:   588556 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.0.3 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description sig 11 in GcvIsVirtualColumn when using view in sql regardless of optgoal setting Workaround Description  Do not use the view.

CR:588594

CR Number:   588594 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) 05 Sep 2009 Fixed 16 Sep 2009 Fixed Description When the optimizer chooses a query plan that includes a Nary-Nested-Loop Join Operator (as seen in showplan output) and at least one of the Scan Operators under the Join is doing dynamic partition elimination (also shown in showplan), the query may return too few rows. This problem ocurrs in queries with at least three tables and which contain join predicates involving columns of the partitioned table that are not part of the partition condition of that table. Workaround Description  Turn on trace flag 342, to disable N-ary NLJ; or turn on trace flag 449 to disable Runtime Partition Elimination. Trace 449 is more likely to impact performance.

CR:588665

CR Number:   588665 Product Name:   Adaptive Server Enterprise Product Component:   MDA/Monitoring Tables Status:   Closed OS:   all Original Version:   15.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 06 Sep 2009 Fixed 06 Sep 2009 Fixed 07 Sep 2009 Fixed Description A new column "Transactions" has been added to the monState table

CR:588681

CR Number:   588681 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) 31 Aug 2010 Bundled Request Description ASE reports "Protocol <XXXXX> not supported within soc_nopen()" error in errorlog. This may be followed by SIGSEGV, SIGBUS or timeslice error and lead to ASE hang. ASE reports incorrect name of the function from which it is raised.

CR:588703

CR Number:   588703 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) 18 Sep 2009 Fixed 29 Sep 2009 Fixed Description Some of the qualifying rows could be missed by an UPDATE statement using at least 2 tables other than the updated table (either directly in the UPDATE statement's FROM clause or within EXISTS/IN subqueries) and the join of these 2 tables involves an expression which contains one of these tables' columns which is also in the UPDATE's SET clause to compute the new values. Workaround Description  set compatibility_mode on

CR:588724

CR Number:   588724 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) 09 Sep 2009 Fixed 15 Dec 2009 Fixed Description The user_name() function incorrectly returns NULL for negative user ids starting in 15.0 GA.

CR:588739

CR Number:   588739 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   aries Fixed Version Build Resolution Date Closure Code (If Appropriate) 08 Sep 2009 Fixed Description In SDC, user cannot create/alter/transfer a DTU/normal table.

CR:588918

CR Number:   588918 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) 27 Nov 2009 Duplicate Description Signal 11 in s__mergelock_in_sub_step ()may be seen in the error log and the spid terminated for query involving text column, nested convert with concatenation to correlated sub-query result.

CR:588954

CR Number:   588954 Product Name:   SCC Web Framework Product Component:   GUI Status:   Closed OS:   Generic Original Version:   3.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 26 Jan 2010 Not a Bug Description

CR:588978

CR Number:   588978 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   aries Fixed Version Build Resolution Date Closure Code (If Appropriate) 01 Oct 2009 Fixed 06 Oct 2009 Fixed Description Error 804, "Unable to find buffer '0x1ead04898' from cache 'default data cache' holding logical page '17179418212732195' in sdes '0x21f3e4700' kept buffer pool for object ''. " may be reported while trying to allocate a new page.

CR:589030

CR Number:   589030 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   aries Fixed Version Build Resolution Date Closure Code (If Appropriate) 07 Sep 2009 Fixed Description The error, "Warning: The database '%.*s' is assigned the %s property, which will be ignored, because the database has a durability of %s." may be reported while changing the durability of the database.

CR:589045

CR Number:   589045 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Windows XP Original Version:   aries Fixed Version Build Resolution Date Closure Code (If Appropriate) 15 Sep 2009 Fixed 18 Sep 2009 Fixed Description ASE running on windows may print the result "-0.000000" for some floating point calculations

CR:589061

CR Number:   589061 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) 10 Sep 2009 Fixed 17 Sep 2009 Fixed Description TEXTPTR() builtin function may sometimes return truncated results with trailing zeros removed. This occurs when a "hash distinct" operator is involved.

CR:589086

CR Number:   589086 Product Name:   Adaptive Server Enterprise Product Component:   Historical Server Status:   Closed OS:   Microsoft Win32s Original Version:   aries Fixed Version Build Resolution Date Closure Code (If Appropriate) 07 Sep 2009 Added to user documentation Description Histsrvr can't work without MS VS2005 Redistributable Package(x86) on winx64 platform

CR:589204

CR Number:   589204 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.3 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Sep 2009 Fixed 16 Sep 2009 Fixed 16 Sep 2009 Fixed Description Historical Server playback incorrect spid value on unix 64bit platform and miss the first sample when the timestamp of sample equal to the start time of playback session

CR:589215

CR Number:   589215 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.0.3 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Feature request to increase ASE limit that only allow 30 character for passwords.

CR:589218

CR Number:   589218 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.0.3 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description ASE LDAP user authentication to support LDAP long token - 40 chars for password.

CR:589220

CR Number:   589220 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) 09 Oct 2009 Fixed 09 Sep 2009 Fixed Description On little endian platforms the builtin is_quiesced(<dbid>) returns always 0 although the given database was previously quiesced.

CR:589235

CR Number:   589235 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) 10 Mar 2010 Fixed 15 Mar 2010 Fixed Description ASE raises an infected with 11 stacktrace in function valid_Xcast with lasterr 10762 if an attempt is made to use a Java method when there is no JavaVM in place. Workaround Description  Configure the JavaVM pluggable component.

CR:589314

CR Number:   589314 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   bharani Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Documentation enhancement request to provide a formula for the calculation of tempdb space needed for the update statistics commands.

CR:589346

CR Number:   589346 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) 01 Feb 2010 Fixed Description The message "Current process infected with signal 11" may be reported with the stack trace including modules 'NormalizeScalar' and 'Optimize' when executing a SELECT statement with a GROUP BY clause which joins two or more views including subquery(s) in the SELECT list of the view(s). The query must be a non-ANSI extended column aggregate query, which references columns outside the GROUP BY list, in the SELECT list or HAVING clause, outside aggregate expressions.

CR:589444

CR Number:   589444 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.2 ESD#6 Fixed Version Build Resolution Date Closure Code (If Appropriate) 09 Sep 2009 Not a Bug Description 1502 QP: underestimated LIOs and PIOs for the scan of an idx after deletes

CR:589446

CR Number:   589446 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   aries Fixed Version Build Resolution Date Closure Code (If Appropriate) 09 Sep 2009 Fixed Description row_count() returns 0 after select-into in tempdb due to a code error.

CR:589473

CR Number:   589473 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) 06 Oct 2009 Fixed 09 Oct 2009 Reservation Made 08 Oct 2009 Fixed 10 Mar 2010 Not a Bug Description When parallelism is involved, some queries having more than 6 tables may timeout earlier during plan enumeration resulting in a merge join plan that uses excessive tempdb space. Workaround Description  A few possible workarounds based on testing: 1.disable parallel or 2. use allrows_oltp optimization goal or 3. disable merge join operator or 4. disable alternative greedy algorithm or 5. increase optimization timeout

CR:589491

CR Number:   589491 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   aries Fixed Version Build Resolution Date Closure Code (If Appropriate) 22 Dec 2009 Fixed Description The authentication mechanism is not displayed in the audit record when doing dbcc table_xfer_check.

CR:589591

CR Number:   589591 Product Name:   Adaptive Server Platform_Specific Docs Product Component:   Release Bulletin for Solaris Status:   Closed OS:   all Original Version:   15.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 03 Feb 2012 EOL'd version. Not to be Fixed. Description Release bulletin in 15.0.3 lacks much of the information included in previous versions. Workaround Description  Read previous RBs.

CR:589619

CR Number:   589619 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) 26 Feb 2010 Fixed 25 Mar 2010 One-off Provided 04 Jun 2010 One-off Provided Description In rare circumstances, the message Current process (0x...) infected with signal 11 (SIGSEGV) together with module names like SeClock::SclResetTimeoutCeil() may appear for queries involving many tables (> 10). Workaround Description  --lower the timeout --try:- set plan opttimeoutlimit 5 --this may work --or set bushy_space_search off --this may work

CR:589650

CR Number:   589650 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX Original Version:   15.0.3 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 23 Oct 2009 Fixed 09 Nov 2009 One-off Provided 22 Oct 2009 Reservation Made Description Error "Msg 325, Level 18, State 1: Server '...', Line 1: Adaptive Server finds no legal query plan for this statement." may be generated for queries involving outer joins to a derived table (and/or views) which itself contains grouping and the user has disabled reformatting, either via "set store_index off" or traceflag 328. The 325 error can also occur in derived tables (and/or views) using unions, and/or when multiple derived tables are in the same query with "store_index" turned off. Workaround Description  Not to disable reformatting and merge join at the same time or compatibility mode.

CR:589657

CR Number:   589657 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX Original Version:   15.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Oct 2009 Fixed 21 Oct 2009 Fixed Description With SQL Replication enabled, queries using "CASE constant expression" (i.e. an expression which is not referencing table columns) may fail with error 401 "Invalid operator for datatype op: = type: MAINTENANCE TOKEN" or error 551 "An unknown EVAL was sent to the execution module."

CR:589674

CR Number:   589674 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 Oct 2009 Fixed 05 Oct 2009 Fixed 02 Oct 2009 Fixed 02 Oct 2009 Fixed Description Sending a Java object using Java/JDBC on the client-side can result in a corrupted object stream being stored in a database table.

CR:589686

CR Number:   589686 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 Feb 2011 Bundled Request Description Feature request to have Msg 935 (WARNING - the timestamp in database '%.*s' is approaching the maximum allowed) always be sent to the errorlog when it is raised.

CR:589780

CR Number:   589780 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   aries Fixed Version Build Resolution Date Closure Code (If Appropriate) 24 Sep 2009 Bundled Request 29 Sep 2009 Fixed 29 Sep 2009 Fixed Description The table-level SQL statement replication threshold setting is not kept consistent on all the nodes of the cluster when it is changed on one of the nodes and the table is not marked explicitly for replication.