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

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

CR:559676

CR Number:   559676 Product Name:   Adaptive Server Enterprise Product Component:   backup server Status:   Closed OS:   all Original Version:   12.5.4 ESD#8 Fixed Version Build Resolution Date Closure Code (If Appropriate) 08 Mar 2009 Fixed 17 Mar 2009 One-off Provided 30 Mar 2009 Fixed 07 Apr 2009 Fixed 04 May 2009 One-off Provided Description DIRECT IO is now supported by Backup Server/Sybmultbuf only for archive devices on Linux platform under traceflag value -D256.

CR:559685

CR Number:   559685 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   pyxis Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 Mar 2009 Fixed Description ASE allows the SA to change the class of an existing server to 'local' which could result in RPC failures and sp_remotesql stored procedure failures.

CR:559710

CR Number:   559710 Product Name:   Adaptive Server Enterprise Product Component:   diagserver Status:   Closed OS:   all Original Version:   pyxis Fixed Version Build Resolution Date Closure Code (If Appropriate) 26 Mar 2009 Fixed Description In rare circumstances error 587 "identity overflow" may be reported into the error log while inserting values into the table with identity column.

CR:559804

CR Number:   559804 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 AP: Use abstract plan in the create view should raise a error or warning.

CR:559807

CR Number:   559807 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 AP: Use abstract plan in the create view.

CR:559928

CR Number:   559928 Product Name:   Adaptive Server Enterprise Product Component:   InstallShield Status:   Closed OS:   all Original Version:   15.0.3 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 26 Feb 2009 Fixed 26 Feb 2009 Fixed 01 Mar 2009 Fixed 02 Mar 2009 Fixed Description User cannot install ASE into a directory when chmod 755 failed.

CR:559985

CR Number:   559985 Product Name:   Adaptive Server Enterprise Product Component:   srvbuild Status:   Closed OS:   all Original Version:   12.5.4 ESD#9 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15 Feb 2009 Fixed 17 Feb 2009 Fixed Description srvbuild and syconfig/sybatch does not recognise case-insensitive commands leading to failure in building the dataserver

CR:560114

CR Number:   560114 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) 19 Feb 2009 Fixed 17 Mar 2009 Fixed Description Execution of a stored procedure containing a statement with a derived table expression may generate Msg 10334, "Permission related internal error was encountered". This error may occur when the procedure execution follows the drop and re-creation of a table referenced in the derived table expression.

CR:560272

CR Number:   560272 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Microsoft Windows Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 Feb 2009 Fixed 19 Feb 2009 Fixed 05 May 2009 Fixed 05 May 2009 Fixed 30 Jun 2009 Fixed Description On Windows platforms, after installing a new Connectivity ESD, ASE may fail to boot with messages: "SSL Plus security module EZ_SECURITY_BUILDER_DSA_MODULE load failed (2030). SSL Plus security module EZ_SECURITY_BUILDER_RSA_MODULE load failed (2031). ... SSL Plus v5.0.4 security modules loaded, 14 errors. Continuing startup without listed modules " Target Version  To Be Determined Workaround Description  Two ways to work Around the issue at the moment. 1- Copy the original sbgse2.dll to C:\sybase\DataAccess\ADONET\dll sbgse2.dll 2- Reinstall the ASE ESD this will roll back the Open Cleint install as well.

CR:560276

CR Number:   560276 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 select into do not show row affected if more and 2147483647 rows this is also releated to the count field in TDS_DONE this is a INT.

CR:560331

CR Number:   560331 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) 19 Feb 2009 Fixed 26 Feb 2009 Fixed 25 Feb 2009 Reservation Made Description Queries that contain an expression in the select-list that has a column value with a LOB datatype (TEXT, IMAGE, UNITEXT) as an input parameter may generate an access violation/segmentation fault with the function, LeAlignedDataRow::readRow, in the calling stack. This failure can occur if the query plan contains a blocking operator (i.e. HASH JOIN, MERGE JOIN, STORE or SORT OPERATOR in showplan output) above the SCAN OPERATOR that reads in the LOB column value. Workaround Description  Use 'set merge_join off' before the query.

CR:560359

CR Number:   560359 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) 29 Jun 2009 Fixed Description When using builtin function object_owner_id(), if the object name is longer than 30 bytes, the builtin could return wrong owner id for the object.

CR:560437

CR Number:   560437 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 Mar 2009 Fixed 04 Mar 2009 Fixed Description Homogeneous SQL statement replication with multiple tables in the query may not work correctly if the query objects are not prefixed by the owner name.

CR:560449

CR Number:   560449 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   Solaris Original Version:   15.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description When you run sp_databases and there is a database >= 2TB, an arithmetic overflow occurs. Workaround Description  Change the column datatype of the temporary table from int to bigint or numeric. But you may need to modify your client applications to accept the data type.

CR:560624

CR Number:   560624 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) 20 Feb 2009 Fixed 16 Jun 2010 One-off Provided Description When a parallel query plan is executed and - at least one SCAN OPERATOR is executed in parallel and - that SCAN OPERATOR does 'Dynamic Partition Elimination' (as seen in showplan) and - that SCAN OPERATOR evaluates a predicate on the partitioning column of a range partitioned table containing the "<" or "<=" operator (i.e. where ptncol <= @v), too few rows may be returned. Workaround Description  1. use serial plan 2. use global index instead of local index

CR:560625

CR Number:   560625 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Feature request for CREATE XML INDEX functionality in ASE. Workaround Description  If we know a particular path we are interested in, that value can be extracted into a computed column during insert and we could build a functional index on it. This could be then later for querying the xml values using xmlextract. Something like : create table tab1 (xmlcol image, title as xmlextract(/chapter/title/text(), xmlcol, returns varchar(250)) materialized) create index title_idx on tab1 (title)

CR:560770

CR Number:   560770 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) 18 Mar 2009 Fixed 11 Apr 2009 Fixed 15 Apr 2009 Fixed 20 Apr 2009 Fixed 21 Apr 2009 Fixed 02 Jul 2009 One-off Provided Description Under certain circumstances, queries referencing a "view or derived table" that is defined using nested "views or derived tables" containing GROUP BY and UNION ALL that contain nested "views or derived tables" with UNION (i.e. this is triply nested) may cause this stack trace. Workaround Description  No workaround has been identified in this case. The union all statement can be changed to union, but, this then gives a different result.

CR:560776

CR Number:   560776 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central Plug-in Status:   Closed OS:   Windows XP Original Version:   15.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 09 Apr 2009 Fixed Description PC Client 1503 ESD#1 Installer log.txt file shows an error message like "Setup.product.install, com.sybase.ismp.ase.wizardbean.SetupLogWizardAction, sis, ERROR: product bean suite does not exist"

CR:560848

CR Number:   560848 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UX Original Version:   15.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 01 Apr 2009 Fixed Description ASE on HP-UX raises error 7718 when executing "alter role <role_name> drop passwd" after "alter role <role_name> add passwd" fails when password exists for the role <role_name>.

CR:560878

CR Number:   560878 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) 26 Mar 2009 Fixed Description Adaptive Server may fail to enforce the "restricted decrypt permission" configuration option on encrypted columns declared with a decrypt_default value under certain circumstances. Workaround Description  If the query is run from within an execute statement, the permission checking is performed as expected and the default decrypt expression is returned. This is demonstrated in the repro.

CR:560954

CR Number:   560954 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) 21 Aug 2009 Fixed 02 Feb 2010 Fixed 07 Feb 2010 Fixed Description Add a dbcc command to enable fixing 100004 checkstorage faults (timestamp value in page header larger than database timestamp).

CR:560979

CR Number:   560979 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UX Original Version:   pyxis Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Apr 2009 Fixed 03 Jun 2009 Added to user documentation 21 Apr 2009 Fixed 23 Apr 2009 Fixed Description Persistent DSF is supported in HP-UX 11.31.

CR:561072

CR Number:   561072 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) 23 Feb 2009 Fixed Description For a select query, if the different columns are being selected and aliased to the same correlation name, it fails to raise 7348 error. For example, The following queries should raise an error: select a.col1 'name', b.col1 'name' from a, b order by name select a.col1 'name', b.col1 'name' from a, b

CR:561105

CR Number:   561105 Product Name:   Adaptive Server Enterprise Product Component:   xpserver Status:   Open OS:   Solaris Original Version:   To Be Determined Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Request configurable shell for xp_cmdshell

CR:561156

CR Number:   561156 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) 23 Mar 2009 Fixed Description Incorrect results containing extra unexpected NULL values could be returned when executing a statement having in its WHERE clause java user defined function calls for objects referenced in the statement with local variables.

CR:561268

CR Number:   561268 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) 09 Mar 2009 Fixed 22 Sep 2010 Bundled Request Description 'set statistics io' can fail to report the componential cost of a deferred update. The cost will however appear in the 'Total actual I/O cost'.

CR:561289

CR Number:   561289 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.0.2 ESD#5 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Optimizer chose a expensive plan for triggers. Workaround Description  Use a AP.

CR:561347

CR Number:   561347 Product Name:   ASE Management Product Component:   Monitoring Agent Plugin Status:   Closed OS:   Generic Original Version:   3.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 Feb 2009 Fixed Description Internal Only

CR:561369

CR Number:   561369 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 2009 Fixed Description When using Kerberos for authentication, the 3rd party errors are only displayed as error numbers which are not human readable. Actual text corresponding to the numbers should also be displayed.

CR:561370

CR Number:   561370 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   pyxis Fixed Version Build Resolution Date Closure Code (If Appropriate) 05 Mar 2009 Fixed Description A message "Entry 14 in pss plock_cache not found on lock chain" along with diagnostic information could be printed on console during the boot of an ASE server.

CR:561385

CR Number:   561385 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) 31 Mar 2009 Fixed Description Restricted compatibility mode could choose a useless non-covered index scan without any sarg and the 302 index selection diagnostics would incorrectly list the index to be covered. It could happen for a non-correlated subquery which itself has a correlated subquery.

CR:561501

CR Number:   561501 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   pyxis Fixed Version Build Resolution Date Closure Code (If Appropriate) 01 Sep 2009 Added to user documentation Description Document that Sybase allows Kerberos clients to login to ASE using different principal names by setting SYBASE_PRINCIPAL="" or -k=""

CR:561513

CR Number:   561513 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.0.2 ESD#6 Fixed Version Build Resolution Date Closure Code (If Appropriate) 05 Oct 2009 Fixed 28 Oct 2009 One-off Provided Description Allow the i_scan() construct to be used in abstract plans to indicate that an index scan is preferred over a table scan is possible. If the query does not contain any columns of the index which are in optimizable predicates or is not covering, then the index will still not be used. Workaround Description  1) workaround is to use i_scan indexname tablename, but ct is unwilling to use this. 2) use i_scan tablename - without brackets 1> select * from t1 where a=1 2> plan " ( i_scan t1 )" 3> go a b ----------- ----------- 1 10 (1 row affected) However, this workaround gives errors on 12.5.4 1> select * from t1 where a=1 2> plan "(i_scan t1)" 3> go Msg 1013, Level 16, State 1: Server 'GURU_125', Line 1: Abstract Plan (AP) : syntax error; line 1, occurring near ')'. Check the AP syntax. /* 1 */ (i_scan t1) a b ----------- ----------- 1 10 (1 row affected) Also, on 15.0.2 , this syntax gives other errors with more complex queries.

CR:561518

CR Number:   561518 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.4 ESD#8 Fixed Version Build Resolution Date Closure Code (If Appropriate) 10 Aug 2009 Presently Not Targeted For Any Future Release Of This Product 02 Sep 2009 Fixed 03 Sep 2009 Reservation Made Description A 1251 error, "An in-use preallocated semaphore cursor was encountered" may be reported under some circumstances if a process that is allocating a new log page is rolled back. Workaround Description  N/A

CR:561522

CR Number:   561522 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UNIX Original Version:   15.0.2 ESD#6 Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 Mar 2009 Fixed 30 Mar 2009 One-off Provided 22 Feb 2010 One-off Provided Description SEGV may occur while running a procedure or a cached statement that has hit an exception in its previous executions. The functions LeScanOp::_LeOpClose()or LeInsertOp::LeOpen()may appear in the stacktrace.

CR:561557

CR Number:   561557 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 Request to have a tool (dbcc) to check that commitservice in ASE (ASTC) can login to remote servers to resolve 2 phase commit transaction.

CR:561559

CR Number:   561559 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 Request to have a other login and probe for commitservice in ASE (ASTC).

CR:561626

CR Number:   561626 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) 28 Apr 2009 Fixed 29 Jun 2009 Fixed 30 Jul 2009 One-off Provided 20 Oct 2009 One-off Provided Description A 8242 error "The table <table_name> in database <dbname> is bound to metadata cache ..." maybe raised when doing delete operation on a DOL table that is bound as hot object using DBCC TUNE 'des_bind' command.

CR:561660

CR Number:   561660 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15 Jun 2009 Fixed 04 Aug 2009 Presently Not Targeted For Any Future Release Of This Product Description CREATE EXISTING TABLE command against MSSQL backend results in Msg 11213 if the remote column is defined with a DEFAULT clause. In the same situation, CREATE PROXY_TABLE fails silently and does not return any error.

CR:561673

CR Number:   561673 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) 29 Jun 2009 Fixed Description The built-in function VALID_NAME() could cause a SIGSEGV (infected with 11) stacktrace if NULL is passed as the second parameter.

CR:561706

CR Number:   561706 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   pyxis Fixed Version Build Resolution Date Closure Code (If Appropriate) 04 Mar 2009 Fixed Description Resource might not work as expected when drop table/index involved because the tempdb page usae count will decrease by 1 for each system table page de-allocation.

CR:561710

CR Number:   561710 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UX Original Version:   pyxis Fixed Version Build Resolution Date Closure Code (If Appropriate) 26 Feb 2009 Fixed 16 Apr 2009 One-off Provided Description Under certain special circumstances, the benign error message, "Internal Error in the IP Link Monitor cannot determine a link state based on returned error" may occur repeatedly in the error log.

CR:561776

CR Number:   561776 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 01 Apr 2009 Fixed Description The built-in function datachange aborts with a segmentation fault when called for statistics on a VIEW.

CR:561797

CR Number:   561797 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.3 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 30 Mar 2009 Fixed Description An error 335 could be raised during a select-into statement when proxy tables with unique indexes are present. Workaround Description  Traceflag 11254 - disable unique index used as alternate rid

CR:561832

CR Number:   561832 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   Windows XP Original Version:   15.0.3 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 03 Mar 2009 Fixed Description Previously when adding a named dump device on Restore Wizard's Select Dump Devices page, if there was no dump device available, clicking OK would result an internal error. This has been fixed.

CR:561876

CR Number:   561876 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   pyxis Fixed Version Build Resolution Date Closure Code (If Appropriate) 22 Mar 2009 Fixed 17 Aug 2009 Fixed 15 Sep 2010 Presently Not Targeted For Any Future Release Of This Product Description Sometimes, ASE terminates connection to the client after error 603, "not enough system session descriptors available" occurs.

CR:561959

CR Number:   561959 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) 23 Mar 2009 Fixed Description In rare circumstances, the message Infected with 11, together with module names like SeClock::SclTrigTimeOut(), may be reported when there is a 10 or more table join, with a union view/derived table involved. Workaround Description  try either set optimeout 0 set bushy_search_space off [if you are in dss mode] or sp_configure "max parallel degree", n where n is > 1. no real workaround the nature of this is that AP, configuration changes and it will not SEGV.

CR:561987

CR Number:   561987 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Microsoft Win32s Original Version:   15.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15 Apr 2009 Fixed 15 Apr 2009 Fixed 15 Apr 2009 Reservation Made Description For query involving <expr> NOT IN <subquery> predicate, a merge join plan under the subquery could lead to stacktrace and access violation in CgpMergeJoin::_cgpInit(). Workaround Description  The ideal workaround is to turn off merge_join for the query:- plan '(use merge_join off)' Or:- set merge_join off <query> set merge_join on Other workarounds:- dbcc traceon (15370) --but this is a global traceflag which will turn off reformatting-based subquery de-correlation. set basic_optimization on

CR:562016

CR Number:   562016 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Windows Original Version:   15.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 25 Mar 2009 Fixed Description Get incorrect db pagesize on winx64 platform if run dbcc checkcatalog twice or after set showplan command.

CR:562036

CR Number:   562036 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) 25 May 2009 Not a Bug Description "set bulk batch size" does not appear to be = to "cis bulk insert batch size" When we use the set command, we only see 1 beginxact and 1 endxact for a select into proxy_table, whereas sp_configure "cis bulk insert batch size", 200 will give us 1 beginxact and 1 endxact for every 200 rows inserted. Workaround Description  use the global sp_configure "cis bulk insert batch size", nnn

CR:562055

CR Number:   562055 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   12.5.4 ESD#9 Fixed Version Build Resolution Date Closure Code (If Appropriate) 26 Feb 2009 Fixed Description ASE produces a stack trace with signal 6 (SIGABRT) when an isql session that was used to establish a CIS connection using SSL, is terminated.

CR:562093

CR Number:   562093 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) 02 Mar 2009 Fixed 05 Mar 2009 Fixed 10 Mar 2009 Fixed Description When loading a jar file containing multiple classes, message 10795, "The file '<your class>.class' contained in the jar does not represent a valid Java class file." can be raised.

CR:562144

CR Number:   562144 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.1 ESD #4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 06 Mar 2009 Fixed 29 Apr 2009 Fixed 03 May 2009 Fixed Description The message "Assertion (fmtlen <= this->maxRowLen) failed" along with stack trace involving modules of vtabremoteaccess.cpp might be printed or ASE Cluster Edition Error 12035 "Failed to return a row for the monOpenObjectActivity monitoring table." may be returned when customer tries to create a temporary table with a a table name >10 characters. The same error might occur for smaller temporary tables in case the user created tempdb has a large enough name Workaround Description  Use Small tempdbnames and temptablenames(sum of characters for dbname and tablename < 15) for tables to be monitored by monOpenObjectActivity

CR:562182

CR Number:   562182 Product Name:   Adaptive Server Enterprise Product Component:   DBISQL Status:   Closed OS:   all Original Version:   15.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 Mar 2009 Not a Bug Description DBISQL displays correct DST time for March 8, 2009 with time values forwarded between 2:00am and 3:00am.

CR:562418

CR Number:   562418 Product Name:   Adaptive Server Generic Docs Product Component:   P&T: Basics Status:   Closed OS:   all Original Version:   To Be Determined Fixed Version Build Resolution Date Closure Code (If Appropriate) 06 Apr 2009 Added to user documentation Description The formula for estimating stored procedure size needs to be updated due to changes in 15.0. The formula now is select count(*) as "estimated size in KB" from sysprocedures where id = object_id("procedurename"). The exact size of a plan in procedure cache can be found in monCachedProcedures

CR:562468

CR Number:   562468 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) 01 May 2009 Fixed Description Incorrect referential interity (RI) check could happen for update/delete when there is mixed datatype equijoin between the RI column and another column. The similar mixed datatype equijoin under a view could also lead to wrong result when the view is joined to itself and has to be materialized into a worktable first. Workaround Description  use "set forceplan on" to eliminate the 547 error.

CR:562472

CR Number:   562472 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UX Original Version:   pyxis Fixed Version Build Resolution Date Closure Code (If Appropriate) 27 Feb 2009 Fixed Description On HP-UX, ASE might report "IP Link Monitor cannot determine a link state based on returned error 229. " and ASE might panic with this error.

CR:562507

CR Number:   562507 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   pyxis Fixed Version Build Resolution Date Closure Code (If Appropriate) 29 Oct 2009 Fixed Description Optdiag output will result in "Internal error: data length mismatch in ct_fetch()" if the table contains a unichar column of size larger than 127 characters.

CR:562556

CR Number:   562556 Product Name:   Adaptive Server Enterprise Product Component:   upgrade Status:   Closed OS:   all Original Version:   15.0.3 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 05 Aug 2009 Fixed Description When upgrading the server which is booted with single user mode, upgrade utility was not able to perform. It required 4 connections to finish the upgrade work. And it can finish the work with only one connection.

CR:562580

CR Number:   562580 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.2 ESD#6 Fixed Version Build Resolution Date Closure Code (If Appropriate) 09 Mar 2009 Fixed Description Attempting to create a table when ASE has run out of locks may cause sig-11 Workaround Description  No work around has been identified.

CR:562584

CR Number:   562584 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 25 Mar 2010 Not a Bug Description Under very rare circumstances, ASE may incorrectly generate 9820 errors by attempting to access partitions with negative numbers. Workaround Description  Upgrade to version 15 as we dont use hsm_strategy() any more

CR:562630

CR Number:   562630 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) 02 Jun 2010 Fixed Description sp_sproc_columns contains several joins that needlessly result in Cartesian products.

CR:562635

CR Number:   562635 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) 29 Apr 2009 Fixed 29 Apr 2009 Fixed Description sp_dbcc_summaryreport is expanded to support the exclusion of faults registered in the dbcc_exclusions table like sp_dbcc_faultreport does.

CR:562636

CR Number:   562636 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 Feat Req: add functionality to sp_modifystats to be able to modify column level statistics for "Range selectivity" and "In between selectivity". Workaround Description  'optdiag input mode'

CR:562643

CR Number:   562643 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX 5.1 Original Version:   15.0.3 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 30 Mar 2009 Fixed 18 Apr 2009 Fixed 04 May 2009 Fixed 15.0.3 ESD#2 04 May 2009 Fixed Description On IBM AIX platform, establishing a server-to-server CIS connection using SSL on Adaptive Server causes a segmentation violation and closes the client connection.

CR:562710

CR Number:   562710 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 Apr 2009 Duplicate Description Executing SELECT TOP N queries against IQ server may cause error 11206.

CR:562796

CR Number:   562796 Product Name:   Adaptive Server Enterprise Product Component:   sybmigrate Status:   Closed OS:   all Original Version:   15.0.3 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 Mar 2009 Fixed Description When the server's page size is not 2k, sybmigrate tool displays the wrong data on "Setup path: Configure work database (source)" screen -> Create on device (source server) combo box.

CR:562870

CR Number:   562870 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) 09 Mar 2009 Not a Bug 10 Mar 2009 Not a Bug Description Previously ASE Plug-in only checked 'enable java' configuration to display Java-related folders even though 15.0.3 ASE's Java in database feature requires additional configuration. This has been fixed.

CR:562873

CR Number:   562873 Product Name:   Adaptive Server Enterprise Product Component:   InstallShield Status:   Closed OS:   all Original Version:   15.0.3 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 01 Apr 2009 Fixed 13 Apr 2009 Fixed 13 Apr 2009 Fixed 14 Apr 2009 Fixed 13 Apr 2009 Fixed Description If user inputs available physical memory for ASE larger than system free memory, there is no warning message in neither installer nor icu tools - srvbuild[res]/syconfig/sybatch, but the optimizing ASE configuration task may fail because it can't allocate the specified memory to server.

CR:562947

CR Number:   562947 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) 02 Apr 2009 Fixed 20 Mar 2009 Reservation Made Description When a cursor is implicitly updatable, i.e. does not have a FOR UPDATE clause or a FOR READONLY clause, and at least one index is available, then a table scan will not be considered. This change will allow a table scan to be considered if there are no unique indices available. The change was placed under optcriteria cr562947 and will be on by default for 15.0.3 ESD #2. Workaround Description  trace flag 15328 can be used to turn off the unique index change for 546125, which would allow any index or table scan to be considered on a cost basis. This means there would be no priority for unique indices on implicitly updateable cursor scans, when the FOR UPDATE clause or FOR READONLY cause is missing.

CR:562949

CR Number:   562949 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.4 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16 Aug 2009 Fixed Description Signal 11 in the errorlog and termination of the spid may be seen involving the modules 'sendtext' ,'run', 'exec_eop' on execution of 'union all' query within a procedure.

CR:562986

CR Number:   562986 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) 23 Mar 2009 Fixed 26 Mar 2009 One-off Provided 08 Apr 2009 One-off Provided 21 Apr 2009 Presently Not Targeted For Any Future Release Of This Product 09 Apr 2009 Fixed Description INSERT-SELECT queries involving an IDENTITY column may cause error 235, "Precision error during implicit conversion of INT value '<nn>' to a NUMERIC field" Workaround Description  Adding a convert function takes care of the problem : insert into test2 (c3) select convert (numeric(6,0), c1) from test1 or We have released 12.5.4 ESD #9.1 to correct this problem. It is available on the EBF download site.

CR:562998

CR Number:   562998 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) 06 May 2009 Consult Complete 05 May 2009 Fixed 04 May 2009 Fixed 14 May 2009 One-off Provided 15 Jul 2009 One-off Provided 16 Aug 2009 One-off Provided Description ASE running on Windows platforms may fail with an access violation, the stack showing the runtime routines free and delete

CR:563020

CR Number:   563020 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX Original Version:   pyxis Fixed Version Build Resolution Date Closure Code (If Appropriate) 10 Jul 2009 Fixed 25 Feb 2010 One-off Provided 09 Mar 2010 Not reproducible with latest version of the product available as of Resolution Date Description Stack trace information on IBM AIX platform had wrong function names, it is corrected with this fix.

CR:563119

CR Number:   563119 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   pyxis Fixed Version Build Resolution Date Closure Code (If Appropriate) 05 Mar 2009 Fixed Description In rare circumstances message "Couldn't find the identity column for object" may be reported into the errorlog while creating objects in multinode cluster environment.

CR:563136

CR Number:   563136 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) 20 Mar 2009 Fixed Description sub-optimal query plan for Distinct with subquery that include Max().

CR:563184

CR Number:   563184 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 Jul 2009 Fixed 12 Nov 2009 Added to user documentation Description Internal only: object type O_LOG was never used. It has been replaced by object type O_PREDICATE.

CR:563236

CR Number:   563236 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 05 May 2009 Fixed 06 May 2009 Fixed Description Under high system load, ASE15.x may randomly hit timeslice errors in cache manager fucntions.

CR:563308

CR Number:   563308 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) 20 Apr 2009 Fixed 22 Apr 2009 Fixed Description The problem described in ASE 15.0.3 ESD#1 Cover Letter for Technical Note "SQL Statement Replication and owner" is solved and supported by Replication Server 15.2 ESD#1 onward.

CR:563378

CR Number:   563378 Product Name:   Adaptive Server Enterprise Product Component:   preupgrade Status:   Open OS:   all Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 06 May 2009 Fixed Description preupgrade utility should identify stored procedures that use depreciated function calls such as reserved_pgs().

CR:563479

CR Number:   563479 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) 06 Mar 2009 Duplicate Description Sybase error code = 102 - Incorrect syntax near ')' during recompile of a statement in the statement cache that has a predicate involving an arithmetic operator outside of a parenthesis. E.g. where col1 =-(1) Workaround Description  set literal_autoparam off go run the query Or change the literal -(1) to -1.

CR:563556

CR Number:   563556 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   Windows XP Original Version:   15.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description The display statistics for tables ( optdiag ) function does not work. when there is no ASE installation on the same machine as PC-Client. Incomplete distribution of PC-client installation.

CR:563639

CR Number:   563639 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   pyxis Fixed Version Build Resolution Date Closure Code (If Appropriate) 06 Apr 2009 Presently Not Targeted For Any Future Release Of This Product 20 Mar 2009 Fixed Description A view is inner to an outer join and the view resdom has a constant string expression. when this expression was used by a builtin function of an outer view outside of it join predicate which could lead to potential null row extension and the outer view also has a union, it could lead to SIG11 in ReslopOp()->EvalConstExpr().

CR:563762

CR Number:   563762 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 CIS performance could be improved by calculating the values of functions that return static values and passing the values in where clauses to the remote server.

CR:563799

CR Number:   563799 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 LDAP feature request to have a unified method of handling users, logins and roles

CR:563861

CR Number:   563861 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   Solaris Original Version:   12.5.4 ESD#8 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Error 11055 and stack trace when incomplete case statement in group by. Workaround Description  Add same case statement condition to group by that was added to select.

CR:563882

CR Number:   563882 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Feature request enhancing sp_displaylogin to allow filtering by locked or expired login status.

CR:563895

CR Number:   563895 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) 11 Jan 2010 Fixed Description Request for a way to suppress new message 4852, meant to inform that minimally-logged bcp is now possible against tables with triggers and/or only nonclustered indexes. Existing traceflag 4805 disables the feature as well as the message. Workaround Description  Traceflag 4805 will disable the message -- and the entire functionality of the new feature.

CR:563896

CR Number:   563896 Product Name:   Adaptive Server Enterprise Product Component:   DBISQL Status:   Closed OS:   all Original Version:   15.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 Mar 2009 Fixed Description Disable the display of 'row(s) affected' messages that made certain system procedures' output hard to read.

CR:564077

CR Number:   564077 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.4 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 Apr 2009 Fixed 20 Mar 2009 Fixed 04 Aug 2009 Presently Not Targeted For Any Future Release Of This Product Description Under certain circumstances a query of the form 'insert into....select....' can cause a stack trace if the select clause refers to two or more tables and a wild card '*' is used in the select clause. The query must result in a wide row for the stack trace to occur. Workaround Description  There are two workarounds available. 1) Specify the names of all columns in the select list of the insert statement. 2) Include the wild card at the end of the list of columns not at the start.

CR:564123

CR Number:   564123 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX 5.1 Original Version:   pyxis Fixed Version Build Resolution Date Closure Code (If Appropriate) 30 Mar 2009 Fixed Description Under rare circumstances, sp_bindcache may report error 19828, "Cache binding failed for database <dbname>.", because the cache to which the object is currently bound is not being locked, even though the lock is granted.

CR:564130

CR Number:   564130 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX Original Version:   pyxis Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Apr 2009 Fixed Description If a pre-15.0 dump is loaded into an SDC server, and the server is rebooted prior to onlining the database, the database will be marked suspect and cannot be onlined. Workaround Description  Execute online database before rebooting ASE

CR:564134

CR Number:   564134 Product Name:   Adaptive Server Platform_Specific Docs Product Component:   Installation Guide for Solaris Status:   Closed OS:   Solaris Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 05 Aug 2009 Added to user documentation Description add 64bit patch info to Installation guide for Solaris 9

CR:564170

CR Number:   564170 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   pyxis Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Apr 2009 Fixed Description Too many primary BCM requeues causing 100% CPU usage.

CR:564171

CR Number:   564171 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   pyxis Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 Mar 2009 Fixed 13 Apr 2009 Bundled Request 22 Mar 2009 Fixed Description For clusters with two or more instances, the message "current process infected with 11" may be reported in the errorlog together with a stacktrace which includes the modules 'cmcc__timedout_request_hdlr', 'cmcc__requeue_ele', 'cmcc_pendq_notifyhndlr', 'cmcc__scan_pendq_timeout_req', 'cmcc_pendq_scan_plc' or 'cmcc__check_duplicate_and_demand_BASTs'.

CR:564192

CR Number:   564192 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   pyxis Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 Mar 2009 Fixed Description Error "01:05:00000:00000:2009/03/10 07:25:09.08 kernel ncheck_checkconn: Unable to identify thread for fd 16" may be reported in the error when multiple engines are configured.

CR:564300

CR Number:   564300 Product Name:   Adaptive Server Generic Docs Product Component:   Other Status:   Closed OS:   all Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 22 Sep 2009 Fixed Description This is in the Install Guide for windows 15.x, and it should go to the job schedulers user guide as well. If Job Scheduler was configured to use the sa account an additional step is necessary whenever the sa password is changed.

CR:564328

CR Number:   564328 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Microsoft Windows Original Version:   15.0.2 ESD#6 Fixed Version Build Resolution Date Closure Code (If Appropriate) 31 Mar 2009 Diagnostic Provided Description Rep Agent reports Log record contains inconsistent data Workaround Description  None known at this time

CR:564344

CR Number:   564344 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) 25 Mar 2009 Fixed 07 Sep 2009 Fixed Description run uninstall in console mode will show NoClassDefFoundError warning message

CR:564392

CR Number:   564392 Product Name:   Adaptive Server Generic Docs Product Component:   System Administration Guide Status:   Closed OS:   all Original Version:   15.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 23 Feb 2010 Added to user documentation Description Documents should be updated with reorg compact and reorg forwarded_rows take exclusive table lock when it find a forwarded rows.