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

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

CR:474457

CR Number:   474457 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) 14 Aug 2007 Fixed Description ASE's with large amounts of memory allocated to them take much longer to boot under 15.0.2 than under 15.0.1 Workaround Description  Turn off sybperf: sp_configure "SQL Perfmon Integration",0

CR:474461

CR Number:   474461 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) 26 Jul 2007 Fixed 26 Jul 2007 Fixed Description The system stored procedure sp_help_rep_agent reports an error message 9225 when displaying the Replication Agent Security Configuration of a database whose replication agent is enabled.

CR:474462

CR Number:   474462 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.1 IP Fixed Version Build Resolution Date Closure Code (If Appropriate) 24 Jul 2007 Fixed 24 Jul 2007 Fixed Description An outerjoin query could return wrong result if there is an OR predicate in the WHERE clause and one OR term is <col>=NULL and <col> comes from the outerjoin inner table.

CR:474593

CR Number:   474593 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.4 ESD#6 Fixed Version Build Resolution Date Closure Code (If Appropriate) 09 Jun 2008 Fixed 03 Jun 2008 Reservation Made 08 Jul 2008 Not a Bug 17 Jul 2008 Fixed Description When configuration option 'select on syscomments.text' is set to '0', Adaptive Server doesn't permit access to 'text' column of syscomments by non-sa users.

CR:474609

CR Number:   474609 Product Name:   Adaptive Server Enterprise Product Component:   diagserver Status:   Closed OS:   Linux Original Version:   15.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 01 Aug 2007 Fixed 13 Jan 2009 Fixed Description ASE may hit OS signal while attempting to print error message on lock resource scarcity. Issue is fixed by using thread-safe API.

CR:474623

CR Number:   474623 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) 27 Sep 2007 Fixed Description When GRANT ROLE or GRANT ... TO role commands succeed in a cluster instance's local temporary database, that role cannot be completely dropped from another node. Attempting to drop the role, results in error: 11178/16/1 "Role '%.*s' cannot be dropped because references to the role exist in one or more local temporary databases. In ASE Cluster, no privileges should be granted to the role in any local temporary database. This role can be dropped after a cluster reboot."

CR:474632

CR Number:   474632 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 Aug 2007 Fixed Description Error 546, "Foreign key constraint violation occurred", may occur when inserting, in parallel, a row into a referenced table.

CR:474641

CR Number:   474641 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX 5.1 Original Version:   15.0.1 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Dec 2007 Fixed Description Queries involving Union All can require large amounts of procedure cache leading to a 701 or timeslice error. Workaround Description  Split the query to reduce the number of selects on the UNION ALL childs.

CR:474704

CR Number:   474704 Product Name:   Sybase ETL Product Component:   ETL Connectivity Status:   Closed OS:   all Original Version:   4.2 EBF #1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 04 Feb 2011 Workaround Description Problem: If a project using Sybase Open Client contains references to n-type columns an insert error will occur. Workaround: Columns of n-type are not accessible via Open Client.

CR:474713

CR Number:   474713 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 Aug 2007 Fixed Description The system procedure sp_helpdevice sometimes shows a description starting with a comma when providing details of devices which are not of type; raw device, file system or block device Workaround Description  N/A

CR:474763

CR Number:   474763 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.1 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 26 Jul 2007 Fixed 26 Jul 2007 Fixed Description When there is an update on the partition key then there is a possibility of getting 12313 error.

CR:474808

CR Number:   474808 Product Name:   Adaptive Server Enterprise Product Component:   InstallShield Status:   Closed OS:   Solaris Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 25 Jul 2007 Fixed 26 Jul 2007 Fixed 07 Oct 2008 Fixed 06 Oct 2008 Fixed Description When setup with "-console" is executed,some parts of License Agreements in Japanese are unreadable.

CR:474843

CR Number:   474843 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) 03 Jan 2008 Fixed Description In Cluster Edition of Adaptive Server, error 905 together with a stack trace which includes the modules 'recover_tempdb' and 'ds__recoverdbs' will be reported in the error log during booting of a cluster instance when configuration parameter 'number of open databases' is set to its minimum value of 5. Target Version  15.1 ESD #1

CR:474854

CR Number:   474854 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 Jul 2007 Duplicate 19 Jul 2007 Duplicate Description In rare circumstances, an allocation page error (such as a 2540 error) may be reported by DBCC CHECKALLOC after Adaptive Server is rebooted following abnormal termination at which time a CREATE INDEX on an empty table was active. For the 15.0.1 CE edition, a 6902 error may be reported during server reboot, node failover, LOAD DATABASE or LOAD TRAN after a CREATE INDEX on an empty table was done. Workaround Description  N/A

CR:474892

CR Number:   474892 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 01 Aug 2007 Fixed 14 Aug 2007 One-off Provided 17 Aug 2005 Presently Not Targeted For Any Future Release Of This Product 27 Aug 2007 One-off Provided Description An application/session that opens many cursors within stored procedures may encounter an 8210 error ("Duplicate of work table descriptor found ..."). The session must quit and restart to alleviate this situation.

CR:474897

CR Number:   474897 Product Name:   Adaptive Server Enterprise Product Component:   srvbuild Status:   Closed OS:   Solaris Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 07 Aug 2008 Fixed Description The 'srvbuild' binary when used on solaris 10 will fail if there is no existing interface file.

CR:475002

CR Number:   475002 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.4 ESD#5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 30 Jul 2007 Fixed 17 Aug 2005 Presently Not Targeted For Any Future Release Of This Product 09 Dec 2008 Fixed 11 Dec 2008 Fixed 10 Feb 2009 Fixed Description ASE may mistakenly terminate a session that was chosen as a deadlock victim in module "get_privilege" with a stack trace in the error log. The modules "s_handle" and "terminate_process" will also be reported.

CR:475014

CR Number:   475014 Product Name:   Adaptive Server Enterprise Product Component:   sqlupgrade Status:   Closed OS:   NA Original Version:   15.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 21 Nov 2007 Fixed Description Update sqlupgraderes to support upgrade to SDC

CR:475031

CR Number:   475031 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) 19 Sep 2007 Fixed 28 Nov 2007 Fixed Description Server may hit msg#403 (Invalid operator for datatype) for some queries involving views (which project explicit NULLs) and "is null" clause.

CR:475040

CR Number:   475040 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   12.5.4 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description When run on an offline database, dbcc checkverify sometimes marks the database as being in use and fails to clear that status when it finishes.

CR:475056

CR Number:   475056 Product Name:   Sybase ETL Product Component:   pEngine Status:   Closed OS:   Windows 2003 Original Version:   4.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 4.5 27 Aug 2008 Added to user documentation 22 Jun 2008 Fixed Description Problem: When using the database lookup function in ETL the use of SQL key words will cause errors. Workaround: SQL also uses square brackets to quote identifiers. Any variable defined by the user is replaced by its value in such a statement. The solution is to disable evaluation of the statement (right-click, remove check mark), with the drawback that dynamically generated statements are no longer possible. This is not the case for the index load component, where the [index] placeholder is treated specially by the GRID engine.

CR:475060

CR Number:   475060 Product Name:   Adaptive Server Enterprise Product Component:   srvbuild Status:   Closed OS:   Solaris Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 06 Aug 2007 Fixed Description srvbuild sets excessive information to a resource file. The result of $SYBASE+$SYBASE_ASE is set to srvbuild.release_directory. The resource file cannot be used by srvbuildres. Workaround Description  Please remove "ASE-15_0" from srvbuild.release_directory.

CR:475072

CR Number:   475072 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UNIX Original Version:   15.0.1 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 Aug 2007 Fixed 02 Aug 2007 Fixed Description Outerjoin might give wrong result when there is a WHERE search clause on some <col> and the <col> is also involved in another expression equijoin join (<col> = <expr>). Workaround Description  Cmdline traceflag 342 to turn off narynljoin might be used as a workaround.

CR:475139

CR Number:   475139 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) 20 Aug 2009 Fixed 20 Aug 2009 Reservation Made 10 Sep 2009 One-off Provided Description Trace Flag 2792 introduced to cause processes to be blocked while attempting to access a table undergoing REORG REBUILD rather than abort with an 8233 error.

CR:475167

CR Number:   475167 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   Solaris Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description ASE 15.0.2 does not work with RTDS 4.0. Workaround Description  None.

CR:475173

CR Number:   475173 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.1 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 25 Jul 2007 Fixed Description When \ is used to concatenate multiple lines for varbinary data, the varbinary data is not parameterized correctly. This may lead to parser syntax error if the cached statement is reparsed.

CR:475180

CR Number:   475180 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 31 Jul 2007 Fixed 07 Aug 2007 Fixed Description Under some circumstances a query involving a join between an outer join and other two or more tables could return incorrect results if the plan chosen to execute the query uses the Nary Nested Loop Join mechanism. Workaround Description  Disable Nary Nested Loop Join via traceflag 342

CR:475233

CR Number:   475233 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Microsoft Windows Original Version:   12.5.4 ESD#6 Fixed Version Build Resolution Date Closure Code (If Appropriate) 09 Aug 2007 Fixed 07 Apr 2008 Presently Not Targeted For Any Future Release Of This Product Description The stored procedure sp_ddlgen generates the 'with override' clause unnecessarily for the DDL corresponding to the case when a database is created with data on one device and log on different device.

CR:475245

CR Number:   475245 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.4 ESD#6 Fixed Version Build Resolution Date Closure Code (If Appropriate) 10 Jan 2008 Fixed 02 Apr 2008 Fixed 02 Apr 2008 Fixed Description In some cases, DDLGen incorrectly misses out the WITH OVERRIDE clause for the last disk piece of a database when generating the DDL for multiple databases named by a pattern specifier. Also in some cases, when generating the DDL for a single database, the WITH OVERRIDE clause is generated for some ALTER DATABASE statements even when it is not necessary.

CR:475264

CR Number:   475264 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 Mar 2008 Fixed 09 May 2008 Fixed Description If a table is created in a stored procedure, subsequent INSERT and UPDATE statements may fail with error 225 (text) if the table is not qualified with exactly the same prefix and name as in the CREATE TABLE statement. Workaround Description  When creating a table in a stored procedure make sure that all subsequent inserts and updates refer to the table in the same form as used in the create statement. If the table is created as dbo.tbl1 then always refer to dbo.tbl1 in subsequent updates in the stored procedure that created the table.

CR:475310

CR Number:   475310 Product Name:   Adaptive Server Enterprise Product Component:   MonitorServer Status:   Closed OS:   Linux Original Version:   12.5.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 06 Aug 2007 Fixed 10 Aug 2007 Fixed 29 Oct 2007 Fixed Description The Monitor Server may crash when used in an SSL environment.

CR:475313

CR Number:   475313 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UX Original Version:   12.5.4 ESD#5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 25 Feb 2008 Fixed 14 Apr 2008 Fixed 29 Feb 2008 Fixed 28 Apr 2008 Presently Not Targeted For Any Future Release Of This Product Description DBCC CHECKSTORAGE reports an erroneous error 100028 on a partitioned table.

CR:475315

CR Number:   475315 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15 Oct 2007 Fixed 25 Nov 2007 Fixed Description In a cluster, a local temporary database can only be accessed by its owner instance. If a table column is encrypted with a key from a local temporary database, and the table is later accessed through another instance in the cluster, the user will get the following error messages: Msg 969, Level 14, State 4: Line 1: You can access database 'local_tempdb1' only from its owner instance 'myserver1'. You cannot access local temporary databases from non-owner instances except to use CREATE DATABASE and DROP DATABASE with local system temporary databases. Msg 15424, Level 16, State 3: Line 1: Adaptive Server cannot access the encryption key with object id '2036302387' in database 'local_tempdb1'. Similarly, the command 'sp_encryption help, <key>, display_cols' will fail in a multi-node cluster with the following error: Msg 969, Level 14, State 4: Procedure 'sp_encryption', Line 277: You can access database 'ftdlinux10_3477_tdb_2' only from its owner instance 'ftdlinux10_3477_ns2'. You cannot access local temporary databases from non-owner instances except to use CREATE DATABASE and DROP DATABASE with local system temporary databases. (return status = -4)

CR:475319

CR Number:   475319 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Oct 2007 Fixed Description At connection time, when the default database associated with a login is a local temporary database and the database is not accessible on the instance, the following messages appear: Msg 969, Level 14, State 4: You can access database 'yellowsta0_13695_tdb_1' only from its owner instance 'yellowsta0_13695_ns1'. You cannot access local temporary databases from non-owner instances except to use CREATE DATABASE and DROP DATABASE with local system temporary databases. Msg 4001, Level 11, State 1: Cannot open default database 'yellowsta0_13695_tdb_1'. Workaround Description  The administrator should avoid setting a defaultdb that is a local temporary database.

CR:475455

CR Number:   475455 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) 27 Jul 2007 Fixed Description ASE may disconnect a session along with a stack trace reported in the error log after error 1105 is raised. The modules "dol_insert", "pg_getdatapage_forinsert" and "ex_reraise_lasterror" will be shown in the stack trace. Workaround Description  Add space to the database to avoid error 1105.

CR:475460

CR Number:   475460 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   Windows XP Original Version:   15.0.2 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 03 Aug 2007 Fixed Description Previously in 15.0.2 ASE Plug-in, if the last opened folder was either Proxy Databases or Archive Databases, the next time ASE Plug-in connected to the server, it would not navigate to the last-opened folder. This has been fixed.

CR:475461

CR Number:   475461 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   16.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15 May 2012 Bundled Request Description Feature request for ability to split and merge data partitions.

CR:475463

CR Number:   475463 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) 27 Jul 2007 Fixed 27 Jul 2007 Reservation Made Description Executing a query that uses the rand2 builtin that is seeded with a stored procedure parameter or variable or a column reference instead of a literal value will generate a signal 11. An example query is: select rand2(column1) from table1

CR:475469

CR Number:   475469 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 30 Nov 2009 DEFER 28 May 2010 Presently Not Targeted For Any Future Release Of This Product 24 Mar 2011 Bundled Request Description Message 4207 Dump transaction is not allowed because a non-logged operation was performed on the database will be raised if the SELECT INTO EXISTING TABLE syntax is used even if the SELECT INTO / BULK COPY dboption is turned off. The SELECT INTO EXISTING syntax was meant for internal use and not intended to be documented or used by end-users. Workaround Description  If the table doesn't exist, just omit the EXISTING keyword. If the table does exist, convert to a INSERT table SELECT [...] FROM statement

CR:475497

CR Number:   475497 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) 27 Jul 2007 Fixed Description If one uses prepared statements and sends parameters which do not match the lengths of column variables then 2780 messages are generated query execution is aborted and Log stacktrace is generated.

CR:475525

CR Number:   475525 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.4 ESD#5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 01 Jan 2008 Fixed 22 Nov 2007 Not reproducible with latest version of the product available as of Resolution Date Description CIS: A query on a view may return wrong result when the view includes a T-SQL outer join involving remote tables. Workaround Description  (1) Use trace flag 11210. But it could impact on performance for other queries. (2) Use trace flag 11291 to disable CIS OR optimization. (3) Use ANSI outer join instead of T-SQL outer join. create view v_test3 as select * from test1_local left join test1_remote on t1_col1 = r1_col1 go select * from v_test3 where r1_col2 is null go

CR:475635

CR Number:   475635 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 21 Sep 2007 Fixed 02 Nov 2007 Fixed Description When executing a SQL query from the SQL debugger the ASE may get killed with spinlock violation errors. This may happen if during the execution of the statement some serious error arrives. Errorlog file will include stack trace dump with modules dbgrpc_control, sqldbg__execsql and ubffree.

CR:475647

CR Number:   475647 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 04 Oct 2007 Fixed 10 Oct 2007 Fixed Description If a CREATE TABLE, CREATE SCHEMA or ALTER TABLE command contains a reference to a column in the local tempdb, the table created will yield the following error when another instance tries to update it: Msg 969, Level 14, State 4: Line 1: You can access database 'local_tempdb1' only from its owner instance 'myserver1'. You cannot access local temporary databases from non-owner instances except to use CREATE DATABASE and DROP DATABASE with local system temporary databases. Msg 436, Level 16, State 2: Line 1: The 'insert' statement will not be executed because the cross-database referential constraint on table 'my_table' cannot be enforced. A table or constraint definition is missing in database 'local_tempdb1'. Contact your System Administrator. Tables should not be allowed to reference data in the local tempdb of a cluster instance.

CR:475675

CR Number:   475675 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   16.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description 1. Using create index <name> on <table> [ column list ] LOCAL UNIQUE INDEX instead of: sp_chgattribute "table_name", "local_unique_index", 1 create unique index index <name> on <table> [ column list ] LOCAL INDEX to create a local unique index. 2. Fix the issue of "select distinct but get duplicated result". 3. Old syntax is also supported. 4. sp_helpindex changes: Printing out "Local Unique Index" for index_local field, instead of "Local Index" for index_local column and "unique" for index_description column.

CR:475689

CR Number:   475689 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) 30 Jul 2007 Fixed 31 Jul 2007 Fixed Description Signal 11 may occur when using current_date() function in the WHERE clause. Workaround Description  trace flag 15352 could be used as a workaround If the problem occurs in other scenarios then trace flag 306 should also be used.

CR:475779

CR Number:   475779 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   AIX 5.1 Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Fidelity requests a new tool for downgrade from ASE 15 logs to ASE 12.5 in case of unresolveable problems in ASE 15.

CR:475799

CR Number:   475799 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) 07 Jan 2008 Fixed Description Optimizer doesnt choose a parallel plan for certain kind of join queries that fulfill the requirements for a parallel-join algorithm.

CR:475804

CR Number:   475804 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16 Mar 2012 Presently Not Targeted For Any Future Release Of This Product Description ESCAPE clause causes query to fail if LIKE predicate > 254 characters

CR:475833

CR Number:   475833 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) 01 Aug 2007 Fixed 02 Aug 2007 Fixed Description Outerjoin might give wrong result when a non-scan derived table is used inner to the outerjoin, such as a vector aggregate view. Workaround Description  Select the output of the view into a temp table, then issue the query. For this repro the workaround is: 1> select * into #myTest from vCLSApbuilder_adr_0 2> select count(*) FROM EQUITYcodes q left outer join #myTest d on d.bb_id = q.bb_id where q.bb_id = 'DBS SP Equity' 3> go (501 rows affected) ----------- 1

CR:475956

CR Number:   475956 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) 13 Jan 2008 Duplicate Description If we have a view owned by a different user from the table it references, then selecting from the view may result in timeslice or 701 error after an index on the table has been dropped and re-created. Workaround Description  Drop and create the view anew OR Qualify the objects with dbo. in the view definition

CR:476044

CR Number:   476044 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) 01 Aug 2007 Fixed 01 Aug 2007 Fixed 21 Sep 2007 Fixed Description The message "Current process ... infected with signal 11 ..." may be reported in module aud_getsdes() with a stack trace reported in the error log when auditing is active. The modules " rvm__audit_table_view_access" and "aud_tabview_ref" will be also reported in the stack trace. Workaround Description  Do not audit.

CR:476068

CR Number:   476068 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) 16 Sep 2007 Bundled Request Description 18278 error occurs when the number of unrelated execution classes exceeds 50.

CR:476079

CR Number:   476079 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) 28 Aug 2007 Fixed Description sp_dbcc_run_differentialreport does not handle the full size of partition ID resulting in error Msg 265, Level 16, State 1, Insufficient result space for explicit conversion of INT value '%d' to VARCHAR field. Workaround Description  Hi Brian, Bug in stored proc, you can modify Partition ID = convert(varchar 3), st2.partitionID) in this select "Parameter Name" = convert(varchar(50), t.type_name), "Index Id" = convert(varchar(3), st2.indid), "Partition Id" = convert(varchar(3), st2.partitionid), "Value1" = convert(varchar(12), value1), "Value2" = convert(varchar(12), value2), "Dev_name" = d.name from #stat_info2 st2, #temp_dbcc_types t, master..sysdevices d to "Partition Id" = convert(varchar(10), st2.partitionid), and then reload this 'sp_dbcc_run_differentialreport' Thanks Saroj

CR:476090

CR Number:   476090 Product Name:   Adaptive Server Enterprise Product Component:   srvbuild Status:   Closed OS:   Solaris Original Version:   15.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 01 Aug 2007 Fixed 03 Oct 2008 Fixed 13 Oct 2008 Fixed Description On some storage devices when creating a new ASE server the srvbuildres utility will erroneously report that the master device does not exist.

CR:476122

CR Number:   476122 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) 20 Sep 2007 Fixed 05 Dec 2007 Fixed Description Enable ASE messaging be able to handle large message for JMS messaging bus.

CR:476131

CR Number:   476131 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 06 Aug 2007 Fixed Description sp_helprotect raises error 17674 when run on a SQL UDF object.

CR:476178

CR Number:   476178 Product Name:   Adaptive Server Enterprise Product Component:   backup server Status:   Closed OS:   Solaris Original Version:   12.5.4 ESD#5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 21 Nov 2007 Fixed 06 Apr 2008 Presently Not Targeted For Any Future Release Of This Product Description DUMP DB command with compression API fails with uninformative error message when dump device does not have enough space for database dumps.

CR:476217

CR Number:   476217 Product Name:   Adaptive Server Generic Docs Product Component:   Transact-SQL Users Guide Status:   Closed OS:   all Original Version:   To Be Determined Fixed Version Build Resolution Date Closure Code (If Appropriate) 09 Jan 2008 Added to user documentation Description Table 12-2 in the TSQL Guide incorrectly indicates that ignore_dup_row is a valid option for unique nonclustered index

CR:476281

CR Number:   476281 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Microsoft Windows Original Version:   15.0.2 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 06 Aug 2007 Fixed Description Queries that reference a SQL UDF in a group by clause may return wrong result.

CR:476314

CR Number:   476314 Product Name:   XML Model Product Component:   XML Model Status:   Open OS:   all Original Version:   tyresias Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Customer would like to be able to select a restriction length when object type is element in a list of report

CR:476338

CR Number:   476338 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.4 ESD#6 Fixed Version Build Resolution Date Closure Code (If Appropriate) 29 May 2009 Insufficient priority to fix Description Error 208 arises if a stored procedure is created with recompile and the table which derived table accesses is dropped and recreated.

CR:476369

CR Number:   476369 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) 30 Aug 2007 Fixed 31 Aug 2007 Fixed Description Client jConnect session running batch inserts with "dynamic prepare= true" is terminated when another user session performs UPDATE STATISTICS command on the insert table. Workaround Description  wrap the entire batch insert and prepare activities in a transaction to avoid any concurrency. Might require to much blocking and locks etc. but it might work for smaller batches.

CR:476401

CR Number:   476401 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 Nov 2007 Fixed Description SSL cipher suite preference changes do not take effect on all instances until the cluster is restarted. When a new listener is started with SSL protocol after "sp_ssladmin setcipher" has changed SSL cipher suite preferences, only listeners started on the local instance will use the new cipher suite preferences. Listeners started on other instances will not see the new preferences until after cluster restart. Workaround Description  Restart the cluster so that all instances see the updated SSL cipher suite preferences from disk.

CR:476404

CR Number:   476404 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15 Oct 2007 Fixed Description On a shared disk cluster, when a password is changed and parameter "immediate" is set, the password is not changed on all concurrent connections on other instances in the cluster. This can result in authentication failures when concurrent connections attempt to establish external connections, use proxy tables, or remote procedure calls. Workaround Description  Users can logout and login again to the cluster to have their in memory password updated with the new password.

CR:476406

CR Number:   476406 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UNIX Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 06 Sep 2007 Fixed 12 Sep 2007 Not a Bug Description When a query is being forced to use an optimization goal and it has a top clause or set rowcount option on, it may chose a different plan than using the optimization goal at a server level.

CR:476441

CR Number:   476441 Product Name:   Adaptive Server Enterprise Product Component:   backup server Status:   Closed OS:   AIX Original Version:   12.5.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Sep 2007 Fixed 02 Apr 2008 Fixed Description On IBM AIX platform, Backupserver can occasionally give false io errors due to a synchronisation issue. The error message could be similar to the following: D00: SYBMULTBUF ERROR: Wait for i/o completion failed: State=zzz, Msg=Attempted to transfer xxxx bytes, but yyyyy bytes were transferred by operating system call read/write. Backup Server: 4.145.2.22: [zzz] Error for device '<device>'. Attempted to transfer xxxx bytes, but yyyyy bytes were transferred by operating system call read/write.

CR:476445

CR Number:   476445 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.4 ESD#6 Fixed Version Build Resolution Date Closure Code (If Appropriate) 06 Nov 2008 Fixed 11 Nov 2008 Fixed Description Under some circumstances when aborting a query using user defined java objects which internally run nested queries using the internal JDBC driver, some errors like 622 error, "Opentable was passed a varno of <id>. Object '<object_name>' in database '<dbname>' already has that session descriptor in use." or 6103 error, "Unable to do cleanup for the killed process" may be reported in the errorlog. Workaround Description  Dont kill queries such as this with Ctrl-C.

CR:476501

CR Number:   476501 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) 16 Aug 2007 Fixed 18 Oct 2007 One-off Provided Description DELETE with READPAST is failing to delete all unlocked rows.

CR:476522

CR Number:   476522 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UX Original Version:   15.0.1 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 29 Aug 2007 Fixed Description When "alter table modify" has an identifier > 125 characters an abstract plan error is incorrectly raised.

CR:476529

CR Number:   476529 Product Name:   Sybase ETL Product Component:   ETL Connectivity Status:   Closed OS:   all Original Version:   4.2 EBF #1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Jan 2008 Workaround Description Problem: If a project using Sybase Open Client contains references to n-type columns an insert error will occur. Workaround: Colums of n-type are not accessible via Open Client.

CR:476536

CR Number:   476536 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 06 Aug 2007 Fixed 16 Aug 2007 Fixed Description Under the following conditions: - A local table has a column that has a foreign key referential integrity constraint to a primary key column in a proxy table, - An INSERT or UPDATE query adds or modifies the foreign key column in the local table, - The result of the INSERT or UPDATE causes a integrity constraint violation, a signal 11 will be raised when the query is rolled back.

CR:476588

CR Number:   476588 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) 29 Aug 2007 Fixed Description Stack trace occurs when identity reservation value specified to reserve_identity() is null.

CR:476631

CR Number:   476631 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.4 ESD#6 Fixed Version Build Resolution Date Closure Code (If Appropriate) 06 Aug 2007 Fixed 30 Apr 2008 Fixed Description When executing a stored procedure with trace flag -T299 (to open temporary tables by name and avoiding recompilation of procedures using externally created temporary tables) the ASE may decide to renormalize the procedure too often. This happens if a procedure includes a statement performing covered index scan on a temporary table created outside of the procedure.

CR:476676

CR Number:   476676 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.4 ESD#6 Fixed Version Build Resolution Date Closure Code (If Appropriate) 28 Sep 2007 Fixed 11 Mar 2008 Not reproducible with latest version of the product available as of Resolution Date Description Query assigning variable and using view with union may provide incorrect assignment of the variable if the variable is also used on the qualification side.

CR:476683

CR Number:   476683 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Feature request to add OLAP functions to ASE include: - Rank functions - Distribution functions - Inverse distribution functions (percentiles) - Hypothetical set functions - Cumulative and other forms of moving aggregates

CR:476761

CR Number:   476761 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 27 Aug 2007 Fixed 31 Aug 2007 Fixed 28 Aug 2007 Fixed Description Under very rare circumstances, a 814 error "Keep count of buffer '<Buffer Address>' in cache '<Cache Name>' holding logical page '<Page Id>' in database '<DbName>' has become negative." may be reported in the ASE errorlog together with a stack trace showing module 'buf_elchousekeeping', 'buf__elcsearch' or 'buf_elcunkeep'. The minimum condition is that at least one index is bound to a cache. Workaround Description  1. Do not bind any index (DOL or APL) to caches. Note that tables can still be bound to caches. In summary : using 'sp_bindcache @cachename, @dbname, @tbname' is fine while using 'sp_bindcache @cachename, @dbname, @tbname, @indname' is problematic. 2. Disable the ELC by running dbcc tune(elc,0) (Not disk persistent, needs to be rerun at each ASE reboot)

CR:476864

CR Number:   476864 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX Original Version:   12.5.4 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 10 Aug 2007 Fixed 14 Mar 2008 Not a Bug Description Parallel execution of a query with subquery returning convert over some aggregate may return incorrect result qualifying too many rows. The problem is likely to happen in the multi engine environment. Workaround Description  Do not use convert function over the aggregate in the subquery result or turn off parallelism.

CR:476869

CR Number:   476869 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UNIX Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Aug 2007 Fixed Description A stored procedure involving CIS tables can cause a signal 11 to happen when used inside a stored procedure that has been marked for deferred compilation.

CR:476902

CR Number:   476902 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) 04 Sep 2007 Fixed 12 Jan 2008 Fixed Description When an INSERT-SELECT query contains a UNION clause in a derived table definition, and the derived table is the source of the SELECT, 206 and 207 errors may occur.

CR:476950

CR Number:   476950 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) 15.0.2 ESD#2 08 Aug 2007 Fixed 12.5.4 ESD#8 09 Aug 2007 Fixed Description If a single character of password is allowed and used in a sql statement, the obfuscated password in audited cmdtext will lose opening delimiter.

CR:476960

CR Number:   476960 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 Sep 2007 Fixed Description A 17783 error "There is already an index named 't' for table 't'" is reported when sp_rename is used to rename an index to the same name as the table to which it belongs.

CR:476982

CR Number:   476982 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Windows W2k Original Version:   12.5.4 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 Oct 2007 Fixed 16 Nov 2007 Insufficient priority to fix Description Error 691 "Encountered invalid logical page '0' while accessing object '<tableid>' in database '<dbid>' ..." may be reported during the execution of WRITETEXT when a text/image column was marked for replication and the data for the given table was inserted using the bulk copy fast interface. Workaround Description  For all versions: Use slow bcp by adding an index to the table. For 12.5x: Turn off and then on again replication, e.g.: sp_setreptable t, 'false' go sp_setreptable t, 'true' go For 15.x: Either the same workaround as the one for 12.5.x or use an index for replication.

CR:476990

CR Number:   476990 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 Aug 2007 Fixed Description A query that involves an insert-select and the select statement has (i) a union clause with select from a proxy table (ii) and a complex conditional expression with subquery in the select list, it generates a signal 11.

CR:476997

CR Number:   476997 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Aug 2007 Fixed Description In a multi-engine system, the message "current process infected with 11" in the module 'LeAPScanContext::LeRequiresMDAUpdate' together with a stack trace which includes the modules 'LeScanContext::updateMDAStats' and 'exec_lava' may be reported in the error log if the configuration option 'enable monitoring' is changed from 0 to 1 while a query is executing concurrently.

CR:477043

CR Number:   477043 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) 10 Sep 2007 Fixed Description A 2631 error, "The maximum number of index levels '255' has been reached for index <indname> of table <tablename> in database <dbname>" may sometimes be encountered while inserting data into a clustered index with a large index key.

CR:477056

CR Number:   477056 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Microsoft Windows NT Original Version:   12.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16 Aug 2007 Duplicate Description Feature Request for application timeout on ASE

CR:477067

CR Number:   477067 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UX Original Version:   12.5.4 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 Oct 2007 Fixed 18 Mar 2008 Presently Not Targeted For Any Future Release Of This Product 17 Aug 2005 Presently Not Targeted For Any Future Release Of This Product Description On HPUX 64 bit machines, the message "current process infected with 11" in the module 'pcexchandlerprint' together with a stack trace which includes module 'traceassert' may be reported in the errorlog when the trace flag 1205 is turned ON.

CR:477152

CR Number:   477152 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.4 ESD#6 Fixed Version Build Resolution Date Closure Code (If Appropriate) 30 Oct 2007 Fixed 03 Apr 2008 Fixed Description sp_fixindex run for the Sysusages clustered index may lead to errors 8204, 806 and ASE boot failure.

CR:477161

CR Number:   477161 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Aug 2009 Fixed 12 Feb 2008 Fixed 20 Feb 2008 Consult Complete 13 Feb 2008 Fixed Description The SySAM License Server and FLEXlm client components have been updated to use FLEXlm version 10.8.

CR:477173

CR Number:   477173 Product Name:   Adaptive Server Enterprise Product Component:   FTS SDS Status:   Closed OS:   Windows W2k Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 21 Aug 2007 Workaround Description 'VdkDocReadBatch' function failed with vdk error '-25 ' " error when index_any >= 16777215

CR:477175

CR Number:   477175 Product Name:   Adaptive Server Enterprise Product Component:   DDLGen Status:   Closed OS:   all Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 Aug 2007 Fixed Description DDLGen fails to generate DDL for a database user if the user has been aliased to another user. Workaround Description  Use DDLGen.jar from ASE 15.0.1. For example create a script like this: % cat workaround.scp #!/usr/bin/ksh PATH=/software/ase1502/shared/jre142_013/bin:${PATH}; export PATH LIB_CONN=/software/ase1502/shared/lib; export LIB_CONN java -ms15m -mx500m -classpath "$LIB_CONN/jconn3.jar:$LIB_CONN/dsparser.jar:/software/ase1501/shared/lib/DDLGen.jar" com.sybase.ddlgen.DDLGenerator $* % workaround.scp -Usa -P -Snstack_1502 -TUSR -Dpubs2 -Npubs2.rob

CR:477178

CR Number:   477178 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) 13 Aug 2007 Fixed Description INSERT-SELECT into local table from remote with a UNION clause should execute in full-passthrough mode. These statements were being executed in non-passthrough mode.

CR:477189

CR Number:   477189 Product Name:   SySAM Product Component:   SyLAPI/Java Status:   Closed OS:   AIX Original Version:   1.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 Sep 2007 Duplicate Description SMT on AIX incorrectly requests double license. Workaround Description  practically none at this time. Alternatives considered are: a. Changing each application to always return 1 cpu (would violate licensing design) b. Forcing customer into buying a 2 cpu license (not good customer relations) c. Customer cannot use SMT on this box (not good customer relations).

CR:477258

CR Number:   477258 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX 5.1 Original Version:   15.0.1 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 28 Aug 2008 Bundled Request Description Configurable option to be added to turn on/off the message "site_hdlr: No LOGCONN for packet from site %d, channel %d"

CR:477268

CR Number:   477268 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Microsoft Windows NT Original Version:   12.5.4 ESD#6 Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Aug 2007 Fixed 13 Aug 2007 Fixed 17 Aug 2005 Presently Not Targeted For Any Future Release Of This Product 25 Sep 2007 One-off Provided Description An UPDATE statement inside a stored procedure on a table created in the same procedure having an IDENTITY column could wrongly increment the IDENTITY column even though it is not affected by the UPDATE.

CR:477311

CR Number:   477311 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) 24 Oct 2007 Fixed 30 Oct 2007 Fixed 26 Oct 2007 Fixed Description Cursor fetch operation may cause a segv stack trace during curs_fetch() processing. Workaround Description  none.

CR:477360

CR Number:   477360 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.1 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 22 Aug 2007 Fixed Description Inserting image using the insert command to ASE through CIS with ADO.net causes data truncation. Workaround Description  One workaround is to use ct_send_data and ct_send_data needs to work on an existing row, which means it does update. So what it can be done to insert null value for the image first and then uses ct_send_data to update the image. There are sample programs in OCS-15_0/sample/ctlibrary/getsend.c or OCS-15_0/sample/db2ct/ex09ct.c to have an idea on how to use the ct_send_data.

CR:477536

CR Number:   477536 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Windows Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 10 Oct 2007 One-off Provided 02 Jan 2008 Fixed Description Compiler Optimizations that rearrange code blocks will lead to (-)ve Keep count in the Partition descriptor.

CR:477538

CR Number:   477538 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) 05 Oct 2007 Fixed 24 Oct 2007 Fixed Description If an "alter database" command adds data space to a device that already contains space for that database, using a command that specifies separate data and log clauses, but the device being added to previously contained mixed log and data, ASE creates a mixed log-and-data section instead of reserving the space for data only. Workaround Description  use sp_dropsegment as workaround: for example: 1>sp_dropsegment logsegment, mar,ttest2 2>go 1> select * from sysusages where dbid = 6 2> go dbid segmap lstart size vstart pad unreservedpgs crdate vdevno ------ ----------- ----------- ----------- ----------- ------ ------------- -------------------------- ----------- 6 7 0 1536 0 NULL 654 Aug 13 2007 6:42PM 8 6 3 1536 2560 0 NULL 2550 Aug 13 2007 6:45PM 10 6 4 4096 2560 0 NULL 2550 Aug 13 2007 6:45PM 9

CR:477540

CR Number:   477540 Product Name:   Adaptive Server Enterprise Product Component:   MDA/Monitoring Tables Status:   Closed OS:   NA Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 Aug 2007 Fixed 23 Aug 2007 Fixed Description The WaitEventID column value in the monSysWaits and monProcessWaits tables for WaitEventID values greater than 336 is reported incorrectly.