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

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

CR:491882

CR Number:   491882 Product Name:   Adaptive Server Enterprise Product Component:   Historical Server Status:   Closed OS:   all Original Version:   15.0.2 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 04 Jul 2008 Fixed Description Historical Server doesn't respond anymore after hs_create_recording_session is issued.

CR:491911

CR Number:   491911 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.1 ESD #1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 23 Feb 2008 Fixed 22 Feb 2008 Fixed Description A shared intent lock on Syscolumns may not be released by Adaptive Server when a session that was running an ALTER TABLE command to partition a table has been chosen as a deadlock victim due to concurrent activity on system catalogs caused by other DDL commands.

CR:491984

CR Number:   491984 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.2 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 21 Feb 2008 Fixed 21 Feb 2008 Fixed Description If you upgrade from (15.0 or 15.0.1) to (15.0.2, esd#1, esd#2), you may not be able to configure "max buffers per lava operator" parameter by sp_configure due to error 18124. Workaround Description  You can directly change the parameter value in your ASE configuration file. In order to change it by sp_configure, you need to insert a row into sysconfigures. manually.

CR:491993

CR Number:   491993 Product Name:   Adaptive Server Enterprise Product Component:   srvbuild Status:   Closed OS:   all Original Version:   15.0.2 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 21 Feb 2008 Fixed 26 Feb 2008 Fixed 21 Feb 2008 Fixed 07 Mar 2008 Fixed Description 'srvbuild' binary fails to create new server if there is no existing interface file.

CR:492004

CR Number:   492004 Product Name:   Adaptive Server Enterprise Product Component:   DDLGen Status:   Closed OS:   Windows Original Version:   15.0.2 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 01 Apr 2008 Fixed Description DDLGen does not generate DDL for a temporary database or an archive database in 15.0.2 ESD#2. This issue can ben seen both in the command line version of DDLGen and the Sybase Central ASE Plug-in. Workaround Description  Use the 15.0.2 (GA) version of ddlgen.jar with the earlier version of Sybase Central

CR:492013

CR Number:   492013 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) 14 Oct 2013 Insufficient priority to fix Description Feature request to add additional T-SQL category commands to sp_options, such as set string_rtruncation,

CR:492035

CR Number:   492035 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.2 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 May 2008 Duplicate Description Add support for "net password encryption" server setting for IQ class servers that support it.

CR:492066

CR Number:   492066 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   To Be Determined Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Feature request to support USE DATABASE statements in stored procedures.

CR:492079

CR Number:   492079 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   all Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 24 Mar 2008 Fixed Description Server Properties dialog Configuration page has been modified to use table cell editors that limit the configuration values for each configuration option. Previously the cell editors were plain text fields which would receive any input, including non-numeric text for numeric values.

CR:492150

CR Number:   492150 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) 22 Feb 2008 Fixed 22 Feb 2008 Fixed Description Under the following conditions: 1) A query has one or more expressions in an IN-list or two or more OR clauses on the same column that contain expressions, such as: select count(*) from opl o , bals b where (substring(o.zb,1,4)=b.bals or substring(o.za,1,4)= b.bals ) 2) The expressions contain references to substituted columns (o.zb and o.za in the example) 3) The optimizer chooses a query plan using the special OR strategy: Showplan will contain a 'SCAN Operator FROM OR List' output 4) The OR-SCAN Operator is under the right hand side of a Nested-Loop Join operator in the query plan 5) The expressions in the IN-list or OR clauses return the same result value for the first row processed, Then too few rows may be returned.

CR:492163

CR Number:   492163 Product Name:   Adaptive Server Enterprise Product Component:   optdiag Status:   Closed OS:   Linux Original Version:   12.5.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16 Mar 2010 Insufficient priority to fix Description Workaround Description  use shorter character filenames in the -i argument, and/or copy the optdiag file to the local directory

CR:492226

CR Number:   492226 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.1 ESD #1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Mar 2008 Fixed 14 Mar 2008 Fixed Description dbcc checktable failed with error 2583. De-allocation of a particular page can take place twice and the OAM counts can possibly go negative.

CR:492267

CR Number:   492267 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.1 ESD #1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 23 Feb 2008 Fixed Description ASE Cluster Edition instance may hang or show unexpected behavior in heavily loaded with multiple connections accessing same database objects.

CR:492289

CR Number:   492289 Product Name:   Adaptive Server Enterprise Product Component:   DBISQL Status:   Closed OS:   Microsoft Windows Original Version:   15.0.2 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 21 May 2008 Fixed 21 May 2008 Fixed Description Previously DBISQL sometimes was not able to reliably cancel a query. This has been fixed

CR:492309

CR Number:   492309 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) 29 Feb 2008 Fixed 05 Mar 2008 Fixed Description An union query with a constant expression in an outer join select list, may return error or wrong result.

CR:492349

CR Number:   492349 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UNIX Original Version:   15.0.2 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 03 Jul 2008 Fixed 01 Jul 2008 One-off Provided Description Connecting to a remote server that has not been started hangs if the retry and delay counts are configured for the remote server in the interfaces file. Workaround Description  remove retry/delay from interfaces file entry for remote server

CR:492368

CR Number:   492368 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.4 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Mar 2008 Fixed 11 Mar 2008 Fixed 25 Mar 2008 Fixed 17 Mar 2008 Fixed Description Using bcp to copy IN rows to a table that uses the allpage (APL) lock scheme, and whose rows have both encrypted columns and null columns, can produce rows that are wrongly formatted but are not detected when the rows are inserted. Replication Agent may report error 9289 when attempting to replicate a DML operation done on the badly formatted rows. Workaround Description  Do not bcp in columns with nulls on tables with encrypted columns. bcp data into table without having columns encrypted, encrypt data after load is finished. A badly formatted row is created only when: - a varying-length column has length greater than 256, AND - the column stored immediately adjacent to it in the row is null, AND - the table contains encrypted columns, AND - the data was populated via 'bcp in' that did column encryption.

CR:492373

CR Number:   492373 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX 5.1 Original Version:   12.5.4 ESD#7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 May 2008 Presently Not Targeted For Any Future Release Of This Product 20 Jul 2008 Fixed Description Implementation of "Large Page" support on AIX platform Workaround Description  n/a

CR:492422

CR Number:   492422 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.1 ESD #1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 27 Feb 2008 Fixed Description 'In rare circumstances, DBCC CHECVERIFY can fail with error 12921, 'A problem was encountered while accessing the faults recorded in the dbccdb database' in a heavily loaded server due to an internal but unreported deadlock.

CR:492426

CR Number:   492426 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.1 ESD #1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 09 Mar 2008 Fixed Description In certain specific cases if there is not enough space in transaction log execution of commands may hit 3935 error

CR:492430

CR Number:   492430 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   NA Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Multiple per-CPU served licenses with different versions (i.e. different purchase dates or different support-end-dates) cannot be accumulated. Workaround Description  1) Use unserved licenses (if ASE 15.0.2 ESD#2 or above) 2) Re-work the customer's order to force co-termination of the licenses. If the support on all licenses is forced to co-terminate on 7th June 2009 then they will be able to generate a single license with quantity of 3 as shown below: INCREMENT ASE_EE SYBASE 2009.0706 permanent 3 \ VENDOR_STRING=SORT=200;PE=EE;LT=CP

CR:492498

CR Number:   492498 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.1 ESD #1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 26 Feb 2008 Fixed 27 Feb 2008 Fixed Description Insert into APL table with both cluster and noncluster index could be rollback as we try to avoid using blocking lock to avoid undetected deadlocks with physical lock.

CR:492552

CR Number:   492552 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   all Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Mar 2008 Fixed 07 Jul 2008 Fixed 01 Apr 2008 Fixed Description New Feature - Sybase Central ASE Plug-in and DDLGen support IPV6 addresses

CR:492554

CR Number:   492554 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 When the target table has a clustered index on 1 datetime column, with_allow_dups, the insert select from a 9mil row archive table takes days to complete. When you add a char(3) column to this clustered index, it completes in an hour. The where clause does not contain the char(3), it only contains the datetime column. Workaround Description  1. Use the second column, 2. apply the index after inserting the rows, 3. use select into with sorted data, then create the index, 4. use a nonclustered index.

CR:492583

CR Number:   492583 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.1 ESD #1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 26 Feb 2008 Fixed Description In rare cases, in multi-instance cluster, the rollback of a transaction may encounter a 692 or 694 error while reading Syslogs.

CR:492586

CR Number:   492586 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) 14 Mar 2008 Fixed 20 Jan 2009 One-off Provided Description Stored procedure created with WITH RECOMPILE option may be executed using existing query plan instead of generating a new one at each execution if some procedural statement is compiled in the deferred mode during runtime execution. Workaround Description  Execute WITH RECOMPILE or start the server with trace -T7730 to disable runtime compilation.

CR:492598

CR Number:   492598 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 25 Feb 2008 Fixed Description Trace output from ASE kernel processes is not printed to the error log when traceflag 3623 is active.

CR:492632

CR Number:   492632 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) 18 Mar 2008 Fixed Description After HK CHORES task fails to generate a new RSA key pair for network password encryption with the message "ks_falloc: Cannot allocate using ubfalloc", you may find approximately 3000 bytes memory leak in Network Buffers. Workaround Description  Increase "additional network memory" until "RSA keypair regeneration failed." message disappears.

CR:492642

CR Number:   492642 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.1 ESD #1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 26 Feb 2008 Fixed Description (Internal Only) An assertion that "Local commit timestamp is less than global commit timestamp" may fail if two thread simultaneously calculate global commit timestamp.

CR:492643

CR Number:   492643 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UNIX Original Version:   15.0.2 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 28 Feb 2008 Not a Bug Description sp_monitorconfig shows very high reuse counts for permission cache entries.

CR:492645

CR Number:   492645 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.2 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 05 Mar 2008 Fixed 06 Mar 2008 Fixed 11 Mar 2008 Fixed Description When statement cache and literal autoparam are on, if a like pattern contains a control character at the end, less rows might be returned. Similar, if a like pattern is a variable or stored procedure parameter that has control characters at the end, less rows might be matched. Workaround Description  set literal_autoparam 0 Or:- Remove the formatting characters from the data.

CR:492681

CR Number:   492681 Product Name:   Adaptive Server Enterprise Product Component:   backup server Status:   Closed OS:   all Original Version:   15.0.2 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 03 Apr 2008 Fixed 29 Jun 2008 Fixed Description Need to print reserved and allocated % values for each disk piece so as to set sp_dumpoptimize parameters.

CR:492688

CR Number:   492688 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) 07 May 2008 Fixed 20 May 2008 Fixed Description Performance issue might be hit for a query with upto 5 joining tables involving cartesian products and/or theta-only joins. Workaround Description  Use an abstract plan to provide hints to the optimizer: select BO.TRADE_NUMBER,BO.CUSTOMER_CODE,C1.CODE_PAYMENT_PARENT from F_BACKOFFICE BO ,M_ACT MA ,C_CLT C1 where BO.ACTIVE_TRADE_STATUS = 1 and BO.VALUE_DATE >= MA.TRADE_DATE and BO.CUSTOMER_CODE = C1.CODE_TRADER plan '( nl_join ( nl_join ( i_scan M_ACT_P2 ( table ( MA M_ACT ) ) ) ( i_scan F_BACKOFFICE_MELLON1 ( table ( BO F_BACKOFFICE ) ) ) ) ( i_scan C_CLT_P4 ( table ( C1 C_CLT ) ) ) ) ( prop ( table ( MA M_ACT ) ) ( parallel 1 ) ( prefetch 2 ) ( lru ) ) ( prop ( table ( BO F_BACKOFFICE ) ) ( parallel 1 ) ( prefetch 16 ) ( lru ) ) ( prop ( table ( C1 C_CLT ) ) ( parallel 1 ) ( prefetch 2 ) ( lru ) )'

CR:492712

CR Number:   492712 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   all Original Version:   15.1 ESD #1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16 Apr 2008 Fixed 28 May 2008 Fixed 02 Jun 2008 Fixed Description A new serials of wizards are added to upgrade a pre-SDC server to SDC server.

CR:492717

CR Number:   492717 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.1 ESD #1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 29 Feb 2008 Fixed 24 Apr 2008 Fixed Description In ASE 15.0 and later, a procedure referencing a temporary table created in a caller procedure may result in signal 11 if the indexes created on the temporary table changes between executions of the caller procedure. This change of indexes on the temporary table could be caused by index creation failure due to resource issues.

CR:492726

CR Number:   492726 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.2 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 28 Feb 2008 Fixed 29 Feb 2008 Fixed Description An invalid column length error may be reported in the error log or 1142 error may be returned when a database is loaded using a database dump that was taken on a platform where the byte order (endian type) is different.

CR:492733

CR Number:   492733 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.1 ESD #1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 29 Feb 2008 Fixed 05 Mar 2008 Presently Not Targeted For Any Future Release Of This Product 06 Mar 2008 Fixed Description A 3484 error, "Recovery encountered an error in acquiring locks for reinstantiated transactions..." may be reported either during boottime, when recovery is processing a prepared distributed transaction, or during node failover (cluster edition only) when recovery is processing an incomplete transaction.

CR:492754

CR Number:   492754 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.2 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Mar 2008 Fixed 10 Mar 2008 Reservation Made Description Improve multi-insert performance with statement_cache & literal_autoparam

CR:492794

CR Number:   492794 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 Feature Request: enhance sp_monitorconfig output for 'additional network memory"

CR:492796

CR Number:   492796 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.4 ESD#7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 May 2008 Fixed 06 May 2008 Fixed 12 Feb 2009 Fixed 16 Feb 2009 Fixed Description In rare circumstances, ASE may not start with the error message, "Error: ld.so.1: ./dataserver: fatal: libsbgse2.so: open failed: No such file or directory" when $SYBASE/$SYBASE_OCS/lib3p64 is not included in LD_LIBRARY_PATH_64. Workaround Description  setenv LD_LIBRARY_PATH_64 $SYBASE/$SYBASE_OCS/lib3p64

CR:492801

CR Number:   492801 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 28 Feb 2008 Fixed 28 Feb 2008 Fixed Description A new option for the display command, 'all' has been added to qrmutil utility.

CR:492810

CR Number:   492810 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.1 ESD #1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 29 Feb 2008 Fixed Description Clusters with only coordinator is up and running, cache update operation never fails. For example, sp_cacheconfig 'default data cache','mixed' operation succeeds instead of failing.

CR:492819

CR Number:   492819 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Mar 2008 Fixed 01 Apr 2008 Fixed Description When delete row involving forward rows, server could hit Signal 11 if it hits out of log space 1105 error.

CR:492825

CR Number:   492825 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UX Original Version:   12.5.4 ESD#7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Mar 2008 Fixed 11 Mar 2008 Not a Bug Description Under the following conditions: 1) There is a parallel query plan with at least one correlated subquery, 2) At least one correlation column or the result value must be variable length datatypes (i.e. INTN, not INT2 or INT4, or VARCHAR, not CHAR). 3) The query plan is being reused (it must be a stored procedure), 4) The query plan is runtime adjusted from a parallel to a serial plan when the plan is reused after the first execution. A signal 11 can occur during execution, which includes the function sq_add_to_cache in the stack trace.

CR:492828

CR Number:   492828 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 May 2013 Fixed 12 May 2013 Fixed Description When run in a database not set to single user mode, dbcc gam 'check' displays a misleading message that the database must be in single user mode - and proceeds to display the results of the check. The database does not need to be in single user mode to run the 'check' option, however, spurious errors may occur due to concurrent activity.

CR:492868

CR Number:   492868 Product Name:   Adaptive Server Enterprise Product Component:   sqlupgrade Status:   Closed OS:   all Original Version:   15.1 ESD #1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 09 Mar 2008 Fixed 09 Apr 2008 Fixed Description srvbuildres upgrade server fails if the interfaces file not in default directory. Workaround Description  Using old interfaces file in default location.

CR:492888

CR Number:   492888 Product Name:   Adaptive Server Enterprise Product Component:   InstallShield Status:   Closed OS:   Linux Original Version:   15.0.2 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 06 Mar 2008 Fixed 02 Apr 2008 Fixed Description Generate RPM packages of ASE 15.0.2 GA including ESD#3 for Linux platform

CR:492947

CR Number:   492947 Product Name:   Adaptive Server Enterprise Product Component:   sqlupgrade Status:   Closed OS:   all Original Version:   To Be Determined Fixed Version Build Resolution Date Closure Code (If Appropriate) 29 Jun 2010 Not reproducible with latest version of the product available as of Resolution Date Description Upgrade fails to boot server with error message: The configuration area in device appears to be corrupt. The server cannot continue and will shut down.

CR:492949

CR Number:   492949 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) 04 Mar 2008 Fixed Description Stacktrace when querying a proxy table mapped to a DirectConnect server and unichar columns are used in the where clause.

CR:492974

CR Number:   492974 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.1 ESD #1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 04 Mar 2008 Fixed Description In rare circumstances, checkstorage may report the error 835, "Illegal attempt to change contents of buffer" followed by a stack trace that includes the module pchk_copy_page().

CR:492978

CR Number:   492978 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.1 ESD #1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 29 Feb 2008 Fixed 20 Mar 2008 Fixed 20 Mar 2008 Fixed Description In rare cases a 692 error for a page belonging to syslogs, might be reported when a transaction is rolled back.

CR:493048

CR Number:   493048 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.2 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 27 Mar 2008 Fixed 29 Apr 2008 One-off Provided 29 Apr 2008 One-off Provided Description The message "process infected with signal 11" may be reported in the error log together with a stack trace which includes the modules 'proc_release' and 'ptnc_replace_ptncond' when an ALTER TABLE DROP PARTITION command is run while concurrent activity on the target table takes place.

CR:493057

CR Number:   493057 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Windows W2k Original Version:   12.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 21 May 2008 Fixed 21 May 2008 Reservation Made Description Using built-in character set conversions, ASE does not raise error 2402 and prevent the insertion of characters that are considered invalid in the client character set.

CR:493078

CR Number:   493078 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) 05 Mar 2008 Fixed Description Equijoin on two correlated subqueries could lead to signal 11 stacktrace in e_eval*LeEvals::LeEvGetFirstEval() during execution.

CR:493097

CR Number:   493097 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   To Be Determined Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Client's setting of SET ROWCOUNT affects the processing of triggers and stored procedures. Workaround Description  Developers can (should) begin each trigger and probably procedure with "set rowcount 0" to prevent client settings from messing with the code logic. Unfortunately, this recommendation is not currently included in the documentation.

CR:493107

CR Number:   493107 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.4 ESD#5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 27 Mar 2008 Fixed 02 Apr 2008 Fixed Description 1) sp_modifylogin <login>, "authenticate with", "ANY" sets a value of 480 but it should be 0. The value set should be the same as sp_addlogin "ANY" which is correctly value 0. 2) Kerberos logins upgraded from pre 12.5.4 to 12.5.4 having status value of 224 can not login. 3) No upgrade action automatically fixes status values 224 and 480 to be 0. sso should execute new stored procedure sp_update_authmech_value to fix the status. Workaround Description  To set all logins to a value of zero which could include upgraded 224 (previous releases) or current which are 480: sp_configure 'allow updates to system tables', 1 update syslogins set status = status & ~480 where ((status & 224) = 224) sp_configure 'allow updates to system tables', 0

CR:493130

CR Number:   493130 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.2 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 04 Mar 2008 Fixed 28 Mar 2008 One-off Provided Description Server signal 11 stacktrace could happen in ResRelOp() when using variable assignment in a DISTINCT query with outerjoin.

CR:493134

CR Number:   493134 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) 25 Jan 2011 EOL'd version. Not to be Fixed. 06 Oct 2014 Bundled Request Description A large network packet size you request may not be used. Or the message "ks_falloc: Cannot allocate using ubfalloc(rnetmempool, 8192)." may be printed out from HK CHORES task in ASE errorlog. Workaround Description  If possible, increase "additional network memory" largely till this problem disppears or stop using larger network packet size than the default network packet size.

CR:493138

CR Number:   493138 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.1 ESD #1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 05 Mar 2008 Fixed Description In ASE Cluster Edition, when an instance executing alter database command on master database fails, the instance performing cluster failover recovery hits error 940.

CR:493142

CR Number:   493142 Product Name:   XML Model Product Component:   XML Model Status:   Closed OS:   all Original Version:   telemaque Fixed Version Build Resolution Date Closure Code (If Appropriate) 05 May 2008 Fixed 05 May 2008 Fixed 15 May 2008 Fixed Description After redirecting the target model OOM, mapping of element lost

CR:493149

CR Number:   493149 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.1 ESD #1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Mar 2008 Fixed Description If a threshold is crossed then it may be handled twice by two different tasks which can result in incorrect threshold pointers.

CR:493170

CR Number:   493170 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.1 ESD #1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 06 Mar 2008 Fixed Description In rare circumstances for clusters with two or more instances , the message "current process infected with 11 in module 'cmcc_bufsearch'" may be reported in the errorlog while doing cache configuration.

CR:493177

CR Number:   493177 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.1 ESD #1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 03 Mar 2008 Fixed Description In rare cases, after an instance leaves the cluster, a process might hit error 1295 when it tries to add log records to Syslogs.

CR:493178

CR Number:   493178 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.1 ESD #1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16 Mar 2008 Fixed Description In rare cases, after instance failover recovery, some cipc message on the instance that did the recovery could be corrupted. The resulted errors could be that server is trying to free a cipc message that is already freed, or server is trying to use a message that is not allocated.

CR:493184

CR Number:   493184 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 Include ROWCOUNT in the list of SET options included in the sysoptions table.

CR:493198

CR Number:   493198 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.4 ESD#5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 10 Mar 2008 Presently Not Targeted For Any Future Release Of This Product 24 Apr 2008 Fixed 05 May 2008 Fixed Description Pre-12.5.4 and pre-15.0.2 logins need an upgrade action so that "Authenticate with" functionality will properly work for KERBEROS logins. An upgrade action should modify the status bits so that values 244 or 480, which have meant 'ANY' in the past, are reset to 0 in the 4 authentication mechanism bits of syslogins.status Workaround Description  See workaround in CR 493107

CR:493220

CR Number:   493220 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 04 Mar 2008 Bundled Request Description The configuration options "cluster heartbeat interval", "cluster heartbeat retries", and "cluster vote timeout" are incorrectly allowed to be set at the instance level.

CR:493223

CR Number:   493223 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.1 ESD #1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 08 Apr 2008 Fixed Description Under rare circumtances , a deferred update of an APL table may result in a 2620 error: "The offset of the row number at offset <offset> does not match the entry in the offset table of the following page."

CR:493227

CR Number:   493227 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 Apr 2008 Fixed Description Optimizer doesn't choose the (join) SARGs present on multiple columns in an index when the columns happen to belong to same tcid i.e. are joined to only one column from outer table. Workaround Description  use set store_index 0 or create an index to avoid reformatting

CR:493255

CR Number:   493255 Product Name:   Adaptive Server Generic Docs Product Component:   System Administration Guide Status:   Closed OS:   all Original Version:   12.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 26 Sep 2008 Added to user documentation Description Document regarding assignment of new connection to engine needs change in System Administration Guide.

CR:493262

CR Number:   493262 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.2 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 01 Apr 2008 Fixed Description A 1763 error, "Cannot insert rows into sysstatistics, due to multiple equal frequency values, please contact Sybase Technical Support." may be reported when "alter table <tabname> partition by roundrobin n" is run on a DOL table with a primary key constraint/ index, where n > 3

CR:493264

CR Number:   493264 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) 07 Mar 2008 Fixed Description infected with 11 may occur in CgEvals::_CgCompVcol() when executing a query which has 400 or more predicates.

CR:493301

CR Number:   493301 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   12.5.4 ESD#7 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Feature request for an option that would prevent any non-ANSI compatible TSQL from running - i.e. block anything that SET FIPSFLAGGER ON would flag as a TSQL extension to ANSI SQL.

CR:493317

CR Number:   493317 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   2.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 22 Aug 2012 Fixed Description When quorum device cannot be accessed, running 'show cluster status' will report an inexplicit error "The cluster entry did not contain any servers"

CR:493342

CR Number:   493342 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.2 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 31 Mar 2008 Fixed Description signal 11 stacktrace might happen during CgpDistinct::_CgpInitSubstitution() call for complex join query using DISTINCT view or DISTINCT derived table on expression(s).

CR:493344

CR Number:   493344 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 Mar 2008 Fixed 31 Mar 2008 Fixed Description A 8201 error will be reported "Keep count of descriptor (objid=<value>, dbid=<value>) was expected to be 1. Instead 2 was found." when SP_FIXINDEX is run against the system table systabstats.

CR:493360

CR Number:   493360 Product Name:   Adaptive Server Enterprise Product Component:   sybconfig Status:   Closed OS:   Windows XP Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 04 May 2010 Fixed 07 May 2010 Fixed 10 May 2010 Fixed 17 May 2010 Fixed Description ASE running on windows reports blocks four "Cannot get value ..." [from registry] error messages every time it starts Workaround Description  Manually added these key into registry First counter First help Last Counter Last Help and restart server.

CR:493362

CR Number:   493362 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 05 Mar 2008 Fixed Description In rare circumstances, the message "current process ... infected with 11" may be reported in module 'dfl_dmp_initflushlist' or 5205 error may be returned during the execution of a DUMP DATABASE command, The modules 'cdfl_dmp_initflushlist' and 'dpdb_main' would also be reported in the stack trace in the error log.

CR:493365

CR Number:   493365 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) 02 Apr 2008 Fixed Description For large join query (more than 6 joining tables), APL clustered index scan might not be used in the final plan even when it would be better. Workaround Description  -T15363 maybe used to workaround the performance problem.

CR:493412

CR Number:   493412 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.2 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 Mar 2008 Fixed 15 Mar 2008 Reservation Made 19 Mar 2008 Reservation Made Description The statements referencing temp table are now cached when statement cache is turned on. Trace flag 467 can be used to turn off this functionality. So when 467 is on, such statements are not cached.

CR:493428

CR Number:   493428 Product Name:   Sybase ETL Product Component:   other Status:   Closed OS:   Windows 2003 Original Version:   4.2.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 28 Aug 2008 Added to user documentation Description ct requests an update on the documentation. ct misses a clear documentation about the Repositories supported by each Version and Platform of ETL. E.g. Where can a one find out if for IQ EEE on WIN Terminal Server an ASE native Repository is supported? And what for AIX?..... Same is true for all ETL Versions. Information needed is: ETL Product, ETL Version, Database Name, Database Version, connect via: Native or ODBC, Driver Version supported.

CR:493451

CR Number:   493451 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   To Be Determined Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Request to reword message 4325 to more clearly indicate that either the dump need not be loaded because all transactions contained committed prior to until_time or that dump contains no transactions that had not committed prior to until_time.

CR:493453

CR Number:   493453 Product Name:   Adaptive Server Enterprise Product Component:   backup server Status:   Closed OS:   Windows XP Original Version:   15.1 ESD #1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15 May 2008 Fixed Description Backup Server in cluster may generate different size dumps for different nodes. The different size is due to dumping additional free pages of database which results in greater size dump.

CR:493461

CR Number:   493461 Product Name:   Adaptive Server Enterprise Product Component:   InstallShield Status:   Closed OS:   Microsoft Windows Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 03 Oct 2008 Duplicate 19 Mar 2010 Fixed Description Installation of 15.0.2 on Windows 32-bit SYB_BACKUP srvnetname is SYB_BACKUP, where it should be {SERVERNAME}_BS, as is in the sql.ini The result is an inability to connect to the backupserver from isql. Workaround Description  sp_dropserver SYB_BACKUP sp_addserver SYB_BACKUP, null, {SERVERNAME_BS}

CR:493463

CR Number:   493463 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) 19 Jan 2010 Duplicate Description sp_dbcc_run_configreport receives error 265 when database size is a terabyte or greater Workaround Description  making the change to declare @dbsize varchar(11) and do the convert using convert(varchar(10) Then recreating procedure sp_dbcc_run_configreport with the changes.

CR:493476

CR Number:   493476 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.4 ESD#7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 01 Jun 2008 Fixed 27 May 2008 Fixed 27 May 2008 Reservation Made Description Incorrect SQL generated when querying a proxy table with an IN clause that compares a constant to a list of columns. Workaround Description  rewrite query with 'or' instead of 'in'

CR:493488

CR Number:   493488 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 27 Mar 2008 Fixed Description ASE 15.0 ODBC driver may encounter an error when unsigned integers are used in a search criteria.

CR:493565

CR Number:   493565 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.0.2 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 01 Apr 2008 Fixed Description signal 11 stacktrace might happen during CgpDistinctSorting::_CgpInit() call for DISTINCT on a scalar aggregate result together with another expression result.

CR:493566

CR Number:   493566 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.4 ESD#7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 Mar 2008 Fixed 15 Mar 2008 Fixed Description Signal 11 may occur for complex queries on multiple views which involves UIV and correlated subquery. Workaround Description  Re-order the views in the FROM clause. Eg. select 1 from view1, view3, view2. Turning on trace flag 4404 also makes the repro work.

CR:493579

CR Number:   493579 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 28 Aug 2009 Fixed Description Provide a periodic warning in the error log if the system time on two instances varies by more than two minutes. The clocks are checked, and the warning generated, every 10 minutes.

CR:493592

CR Number:   493592 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) 11 Mar 2008 Fixed 11 Mar 2008 Reservation Made Description If merge-join is used between a proxy table mapped to a table in DB2 and a local ASE table on a character field that contains numeric characters, some matches may be missing in the result set. Workaround Description  set merge-join off

CR:493608

CR Number:   493608 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.1 ESD #1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 30 May 2008 Fixed 27 Jul 2009 Presently Not Targeted For Any Future Release Of This Product 27 Jul 2009 Insufficient priority to fix Description Query on an audit table will hang when the audit table is full.

CR:493648

CR Number:   493648 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.2 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16 Mar 2008 Fixed Description ASE gives ip address as network name when ipv6 address is used in interfaces file.

CR:493654

CR Number:   493654 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.1 ESD #1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Mar 2008 Fixed Description In rare circumstances while dropping a system table message 3702 may be reported in the errlog instead of message 3708.

CR:493669

CR Number:   493669 Product Name:   Adaptive Server Generic Docs Product Component:   Using Sybase Failover In a HA System Status:   Closed OS:   all Original Version:   12.5.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 09 Oct 2008 Added to user documentation Description clear doc's on @@cmpstate values in SDC or in non-HA env. @@cmpstate is >= 0 in HA-env, and it has no meaningful value in SDC or in non-HA env (it will be < 0).

CR:493684

CR Number:   493684 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) 19 Mar 2008 Fixed Description Using DISTINCT on expression involving a char type column and also having equijoin between the column and another different length char type column could lead to wrong result.

CR:493701

CR Number:   493701 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   DOS Original Version:   12.5.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Mar 2008 Fixed 12 Mar 2008 Fixed 14 Mar 2008 Fixed 31 Mar 2008 Fixed Description On tables where all of the following occur: 1) lock scheme is APL (All Page Locking), 2) table has at least one encrypted column, 3) table has at least one variable length column, 4) a row has more than 255 bytes of fixed length data, then BCP IN on those tables will fail to insert rows.

CR:493711

CR Number:   493711 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 01 Apr 2008 Fixed 09 Jun 2008 Fixed 12 May 2008 Fixed Description In badly partitioned applications, stale copies of pages of dataonly locked tables might be scanned on different nodes.

CR:493732

CR Number:   493732 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.1 ESD #1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Mar 2008 Fixed Description The command DBCC CHECKSTORAGE may abort with the error 871, "Process is trying to release a latch on buffer without holding a latch on it." if the last log page is found cached and more recent in a remote node when checking SYSLOGS.

CR:493736

CR Number:   493736 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.2 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 29 Apr 2008 Fixed 02 May 2008 Fixed 11 Aug 2008 Fixed 11 Aug 2008 Fixed 04 Dec 2008 One-off Provided 04 Dec 2008 One-off Provided Description During UPDATE STATISTICS, the number of extended steps, that is, the product of the requested step count and the histogram tuning factor, is restricted to the maximum of 10% of the number of rows in the table and the requested step count. However, if the histogram tuning factor is at the default value of 20 and the proposed number of extended steps is greater than 400, then the actual number of steps in the histogram is restricted to a maximum of the requested step count and 400.