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

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

CR:465448

CR Number:   465448 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.1 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Apr 2007 Fixed 17 Apr 2007 Fixed Description Incorrect results could be returned when a mergejoin with at least two equijoin predicates is placed over a nested loop join that uses a reformatting strategy for the inner table and the outer scan of the nested loop join involves a unique index. Workaround Description  Use the store_index set option before running the query to disable reformatting at the session level.

CR:465449

CR Number:   465449 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   all Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Apr 2007 Fixed Description Previously on Server Properties General page the OS and Platform field displayed different information depending on whether UA (Unified Agent) was available (OS/Platform from the UA was preferred over build OS/Platform from the version string). To avoid confusion, ASEP now clearly labels OS/Platform as "Build OS" and "Build platform". Add additional host OS/Platform fields are shown only when UA is available.

CR:465509

CR Number:   465509 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Windows XP Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 01 May 2007 Fixed Description When a key encrypted with system encryption password is used in a set encryption passwd statement, there is no error given.

CR:465523

CR Number:   465523 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 Apr 2007 Fixed 19 Apr 2007 Fixed Description Wrong result could happen for an outerjoin whose only outer table is is a scalar aggregate view/derived table.

CR:465538

CR Number:   465538 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) 26 Apr 2007 Bundled Request Description If alter table command is decrypting a column in a table which has more than one column encrypted with the same key encrypted with user password, the user will get the error message that the user password has not been set.

CR:465553

CR Number:   465553 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 Jun 2007 Fixed 12 Jul 2007 Fixed Description Message for 15.0.2 ESD #1 and 12.5.4 ESD #7. If a stored procedure or a cached statement references an encrypted column then if 1) the referenced table and the encryption key are dropped and recreated and 2) the stored procedure or cached statement is re-executed the following error may be raised: "Msg 15424, State 4 "Adaptive Server cannot access the encryption key with object id '<obj_id>' in database '<database_name>'.

CR:465569

CR Number:   465569 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 Apr 2007 Fixed 18 Apr 2007 Fixed Description sig11 might happen in LeSarg::mapSarg() during execution when one of the joining tables is a proxy table and the join predicate involves an expression on columns from both the proxy table and some local table.

CR:465618

CR Number:   465618 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX Original Version:   15.0 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Apr 2007 Fixed 14 Apr 2007 Fixed 08 Oct 2007 Fixed Description A select into statement with NULL timestamps may cause siganl 11

CR:465644

CR Number:   465644 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Apr 2007 Fixed Description The default db after user login is the not the default db saved in syslogins. It's the master database instead.

CR:465650

CR Number:   465650 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 Jan 2008 Fixed Description Allow Replication Agent to differentiate the 'dump tran' command from the 'dump tran with standby_access' command, so that replication can take different actions for both commands.

CR:465725

CR Number:   465725 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) 13 Apr 2007 Fixed Description The showplan ouput for the SCAN operator of a SQL statement that requires reading the rows of a semantically partitioned table may incorrectly contain '[ Using Dynamic Partition Elimination ]' when a global index is used for the scan and the statement contains predicates on the partitioning key columns.

CR:465736

CR Number:   465736 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   macosx Original Version:   12.5.4 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Jun 2007 Fixed 12 Jun 2007 Fixed 20 Mar 2008 Presently Not Targeted For Any Future Release Of This Product Description Timing issues related to signal handling require the implementation of an alternate signal stack via the system call sigaltstack().

CR:465762

CR Number:   465762 Product Name:   Adaptive Server Enterprise Product Component:   sqlupgrade Status:   Closed OS:   Linux Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 27 Apr 2007 Fixed 23 Apr 2007 Fixed Description The default number of locks has been increased from 5000 to 10000.

CR:465765

CR Number:   465765 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UX Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Jun 2007 Fixed Description If a licensed feature is enabled in the config file, and its license is expired, then the ASE fails to online engines. Workaround Description  1) sp_configure 'enable real time messaging', 0 go 2) reboot the ASE Then everything is ok : sp_configure 'enable real time messaging', 1, 'tibco_jms' go sp_engine 'offline', 1 go sp_engine 'online' go At this time, it will succeed.

CR:465823

CR Number:   465823 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UX Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 27 Jun 2008 Fixed Description Floating point overflow is not always detected correctly.

CR:465825

CR Number:   465825 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 Mar 2010 Not reproducible with latest version of the product available as of Resolution Date Description Error 225 Cannot run query--referenced object (name NAME NOT RECOVERABLE) dropped during query optimization can be caused by inconsistent naming such as a mix of owner.object vs object references. Workaround by rewriting to use consistent naming. Workaround Description  In this case, error was caused by inconsistent naming (dbo.tab1 vs tab1) in query, and the error is avoided by using consistent naming.

CR:465853

CR Number:   465853 Product Name:   Adaptive Server Enterprise Product Component:   MonitorServer Status:   Closed OS:   Solaris Original Version:   12.5.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Apr 2007 Fixed 20 Apr 2007 Fixed 20 Apr 2007 Fixed 20 Apr 2007 Fixed Description 64bit monserver on solaris can have very high cpu utilization at times due to not being linked with the kernel threads libraries (/usr/lib/lwp/64) Workaround Description  setenv LD_LIBRARY_PATH_64 /usr/lib/lwp/64 will pick up kernel threads.

CR:465917

CR Number:   465917 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Microsoft Windows NT Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 Jun 2008 Fixed Description Adaptive Server Enterprise running on the Windows platform may encounter "SERIOUS UNHANDLED EXCEPTION" with exception number e06d7363.

CR:465953

CR Number:   465953 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Windows XP Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16 Apr 2007 Fixed 26 Apr 2007 Fixed 20 Apr 2007 Fixed 25 Apr 2007 Fixed Description Changing column encryption key causes stack trace if a decrypt_default is defined on the column.

CR:465962

CR Number:   465962 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) 22 Jan 2008 Third Party Problem 03 Jan 2008 Added to user documentation Description Under heavy load such as insalling installmaster via isql, isql might hang. This issue is resolved with new OCS esd #12.

CR:465967

CR Number:   465967 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Windows XP Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 24 Apr 2007 Bundled Request Description Key ownership can be transferred to a user who already has a key copy on the key. Workaround Description  This CR has two workarounds: Since the new key owner can drop his key copy, if we allow the original owner to be modified to a user with an existing key copy, the new owner can drop his key copy and use the base key. The other workaround is that the original key owner checks that the new key owner does not have any key copies and if he does, drops the key copy before making him the new owner.

CR:465981

CR Number:   465981 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.1 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 08 May 2007 Not reproducible with latest version of the product available as of Resolution Date 17 Jan 2008 One-off Provided 10 Sep 2007 One-off Provided 08 Jan 2008 Fixed 04 Jan 2008 One-off Provided 06 Dec 2007 One-off Provided 16 Jan 2008 Presently Not Targeted For Any Future Release Of This Product 04 Jan 2008 One-off Provided 08 Jan 2008 Fixed 09 Jan 2008 One-off Provided 09 Jan 2008 One-off Provided 08 Jan 2008 Presently Not Targeted For Any Future Release Of This Product 04 Jan 2008 Fixed 15 Jan 2008 One-off Provided 23 Jan 2008 One-off Provided 06 May 2009 Fixed Description In rare circumstances, Adaptive Server may hang and a stack trace which includes the modules 'buf__writewait' and 'buffree' may be reported when running a select-into statement. Workaround Description  To workaround this problem, disable the Housekeeper wash task (HK Wash) by setting dynamic configuration parameter 'housekeeper free write percent' to 0.

CR:465987

CR Number:   465987 Product Name:   Adaptive Server Enterprise Product Component:   Language Modules Status:   Closed OS:   all Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 Apr 2007 Fixed 15.0.2 18 Apr 2007 Fixed Description The ASE server.loc file and sybinit/*.loc files have been moved under the ASE-15_0 directory tree, in order to reduce issues overlaying locales files from other Sybase products.

CR:466048

CR Number:   466048 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) 27 Oct 2007 Fixed 31 Oct 2007 Fixed 08 Nov 2007 Presently Not Targeted For Any Future Release Of This Product 15 Nov 2007 Fixed 30 Oct 2007 Reservation Made 21 Nov 2007 Fixed Description Changes have been made to reduce procedure cache usage with large histograms.

CR:466114

CR Number:   466114 Product Name:   XML Model Product Component:   XML Model Status:   Closed OS:   Windows 2000 Original Version:   telemaque Fixed Version Build Resolution Date Closure Code (If Appropriate) 29 Apr 2007 Fixed Description A PowerDesigner 12.1 issue has been identified with XML Schema models using the REDEFINE feature of the XML Schema language and redefining an object that is redefining itself.There are no issues with the generated XML Schema code.

CR:466177

CR Number:   466177 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) 20 Apr 2007 Fixed Description Using "select *" or "select into", with user created types, across databases, the destination table incorrectly retains the user type information from the source table/database.

CR:466232

CR Number:   466232 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   AIX Original Version:   12.5.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 07 May 2007 Presently Not Targeted For Any Future Release Of This Product Description FR: SSO has the DBO authority to grant/revoke permissions on User-DB

CR:466277

CR Number:   466277 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) 28 May 2007 Presently Not Targeted For Any Future Release Of This Product 28 May 2007 Presently Not Targeted For Any Future Release Of This Product Description Access to an archive database that is using either a compressed database dump or a compressed transaction log dump may result in unnecessary waits for buffere in the compression memory pool despite the pool size being configured as twice the compression block size per concurrent user accessing the archive database. Workaround Description  Increase the size of the compression memory pool: sp_configure "compression memory pool", <current size * 1.5>

CR:466284

CR Number:   466284 Product Name:   XML Model Product Component:   XML Model Status:   Closed OS:   Windows XP Original Version:   telemaque Fixed Version Build Resolution Date Closure Code (If Appropriate) 27 Apr 2007 Fixed Description Forward engineer returns namespacePrefixA translation error: unresolved member targetNamespace Workaround Description  However i have a workaround that will enable the generation of the schema after the reverse. You can fix it in the properties of the object language from XML Schema::Profile\\Association\\Templates\\Helpers\\roleA\\namespacePrefixA to be able to forward engineer again %Name% .if (%nsPrefixA%) %nsPrefixA% .elsif %Model.targetNamespace% %Model.tnsPrefix% .endif However, when doing this, the generation process runs into 462247, ie. the elementFormDefault="unqualified" elementFormDefault="unqualified" gets generated twice. So the one elementFormDefault="unqualified" should be attributeFormDefault="unqualified" then it works when trying to reverse it again

CR:466289

CR Number:   466289 Product Name:   XML Model Product Component:   XML Model Status:   Closed OS:   Windows XP Original Version:   telemaque Fixed Version Build Resolution Date Closure Code (If Appropriate) 15 Sep 2008 Fixed Description replica synchronization broken when adding an element to sequence symbol not built in referencing model Workaround Description  Workaround is to delete the symbol ONLY of Element_1 /Element_1 in referencing model then go to Symbol > Show Symbols... check Element_1 and click OK. Sub-element Element_2 is back.

CR:466313

CR Number:   466313 Product Name:   Adaptive Server Enterprise Product Component:   InstallShield Status:   Closed OS:   NA Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 23 Apr 2007 Fixed Description License server is not started after the installation.

CR:466315

CR Number:   466315 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) 02 May 2007 Fixed 20 Apr 2007 Fixed Description User data in text/image column may become garbled when the database is upgraded from 11.9.x to 15.0.1 directly by using dump and load, and the endian type of the source and target platform is different. Workaround Description  1. Load the 11.9.x dump file on 12.0.x or 12.5.x (or 15.0.x on same endian type of platform) 2. Run sp_rebuild_text or dbcc rebuild_text(all) in the database 3. Dump the database again 4. Load the database on 15.0.1

CR:466358

CR Number:   466358 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Getting overdraft messages in errorlog before legit licenses are being used Workaround Description  The customer can workaround this by specifying options in the $SYBASE/SYSAM-2_0/bin/SYBASE.opt options file. 2 possibilities in this case would be:- 1) Revoke the sybase.lic overdraft license by setting the following option: MAX_OVERDRAFT ASE_CORE:VERSION=2007.06030 0 2) Specify which ASE gets which license by associating each with a specific host (server1; server2,3,4,5 used as examples below). NB: the sybase.lic licenses have version 2007.06030 and the sybase2.lic licenses have version 2007.12180. Since there are 4 licenses in sybase2.lic then there are probably 4 hosts that would use them: INCLUDE ASE_CORE:VERSION=2007.06030 HOST server1 HOST_GROUP Servergrp server2 server3 server4 server5 INCLUDE ASE_CORE:VERSION=2007.12180 HOST_GROUP Servergrp Similar to the above you could EXCLUDE the HOST_GROUP from using ASE_CORE:VERSION=2007.06030. I'd recommend using 1), as they will still have an overdraft license from the sybase2.lic file. Using 2) could become a maintenance issue as they'll need to associate each ASE with a specific license. After modifying the licenses file, the License Server needs to be told to refresh it's options, via: $SYBASE/SYSAM-2_0/bin/sysam reread

CR:466370

CR Number:   466370 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UX Original Version:   15.0.1 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16 Aug 2010 Duplicate 16 Jan 2008 Presently Not Targeted For Any Future Release Of This Product Description sp_sysmon runs slowly and reports errors number 1508 ("Createindexabortedonduplicaterows") when run on a server that has a large number of spinlocks allocated. Workaround Description  Run sp_sysmon with the "clear" option. Note that doing this will clear the monitor counters at the time that sp_sysmon starts.

CR:466435

CR Number:   466435 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) 13 Jun 2007 Presently Not Targeted For Any Future Release Of This Product 14 May 2007 Fixed 07 Jun 2007 Fixed 07 Jun 2007 Fixed 18 Jun 2007 Fixed 14 Jun 2007 Fixed Description A LOAD DATABASE command might hang in cases where the "number of open databases" configuration parameter is less than the number of databases on the server and an earlier attempt to load another database with a cross-architecture database dump, failed. Workaround Description  Increase the "number of open databases" configuration parameter to the number of databases on the server so that scavenging does not occur.

CR:466444

CR Number:   466444 Product Name:   Sybase ETL Product Component:   GUI Status:   Open OS:   Windows XP Original Version:   4.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) Failed 11 Jan 2008 Workaround Description Problem: In the data type list "double", "CLOB", "BLOB" are available types but they are internal ASE data types that will cause errors if used. Workaround: Don't use these data types. They will be removed as options in a future release.

CR:466445

CR Number:   466445 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) 01 Aug 2007 Fixed 12 Aug 2007 Fixed Description DBCC object_stats for a specific object does not clean the resources after printing the stats information. As the task is not closing the database after reporting the required information it will be accumulated in the task PSS and will exceed the limit on the number databases used by the statement. Workaround Description  exclude the object and only use per dbid.

CR:466490

CR Number:   466490 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.0.1 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Nov 2007 Fixed 16 Nov 2007 Fixed Description Under some circumstances a query which joins data from an EFTS text index with local data and also includes subqueries can perform poorly with ASE 15 compared to earlier releases. Workaround Description  It maybe difficult for Starz Encore Group to workaround since they can't change the query which is issued. Their application queries the database via Hibernate and they don't directly write the SQL. ----------------------------------------------------------------- For the original big query, materialize the subqueries having text index to temporary tables may simplify the query and improve the performance for our inhouse test environment. e.g. /********** materialize the subqueries using temp tables */ select title.media_title_id into #tab_sub1 from MEDIA_TITLE title inner join I_NEW_MEDIA_TITLE ititle on title.fts_id = ititle.id where ititle.index_any = 'Robert' group by title.media_title_id go select title.parent_media_title_id into #tab_sub2 from MEDIA_TITLE title inner join I_NEW_MEDIA_TITLE ititle on title.fts_id = ititle.id where ititle.index_any = 'Robert' group by title.media_title_id go select title.media_title_id into #tab_sub3 from MEDIA_TITLE title inner join MEDIA_TITLE_ARTIST_XREF artist_xref on title.media_title_id = artist_xref.media_title_id inner join ARTIST artist on artist_xref.artist_id = artist.artist_id inner join I_NEW_ARTIST_FULL_NAME iartist on iartist.id = artist.fts_id where title.enabled = 'Y' and iartist.index_any = 'Robert' group by title.media_title_id go select title.parent_media_title_id into #tab_sub4 from MEDIA_TITLE title inner join MEDIA_TITLE_ARTIST_XREF artist_xref on title.media_title_id = artist_xref.media_title_id inner join ARTIST artist on artist_xref.artist_id = artist.artist_id inner join I_NEW_ARTIST_FULL_NAME iartist on iartist.id = artist.fts_id where title.enabled = 'Y' and iartist.index_any = 'Robert' group by title.media_title_id go /************* The original query has been modified, using #tab_sub* to **************** replace the subqueries having text index ***/ select distinct title.media_title_id, title.TITLE from MEDIA_TITLE title left outer join MEDIA_TITLE episode on title.media_title_id = episode.parent_media_title_id inner join MEDIA_TITLE_COLLECTION_XREF collection_xref on title.media_title_id = collection_xref.media_title_id inner join COLLECTION collection on collection_xref.collection_id = collection.collection_id left outer join MEDIA_VERSION version on title.media_title_id = version.media_title_id left outer join MEDIA_VERSION episode_version on episode.media_title_id = episode_version.media_title_id left outer join MEDIA_FILE file on version.media_version_id = file.media_version_id left outer join MEDIA_FILE episode_file on episode_version.media_version_id = episode_file.media_version_id left outer join AFFILIATE affiliate on file.affiliate_id=affiliate.affiliate_id left outer join AFFILIATE episode_affiliate on episode_file.affiliate_id=episode_affiliate.affiliate_id left outer join PRODUCT_MARKETING product on file.product_id=product.product_id left outer join PRODUCT_MARKETING episode_product on episode_file.product_id=episode_product.product_id where title.parent_media_title_id is null and (lower(affiliate.affiliate_name)='vongo' or lower(episode_affiliate.affiliate_name)='vongo') and (title.enabled = 'Y') and (getdate() between collection.first_effect_dt and collection.last_effect_dt and collection.enabled = 'Y' and collection_xref.enabled = 'Y') and ((getdate() between file.first_effect_dt and file.last_effect_dt and file.enabled = 'Y') or (getdate() between episode_file.first_effect_dt and episode_file.last_effect_dt and episode_file.enabled = 'Y')) and (version.enabled = 'Y' or episode_version.enabled = 'Y') and (( title.media_title_id in (select media_title_id from #tab_sub1) or title.media_title_id in (select parent_media_title_id from #tab_sub2)) or ( title.media_title_id in (select media_title_id from #tab_sub3) or title.media_title_id in (select parent_media_title_id from #tab_sub4))) order by title.title go

CR:466507

CR Number:   466507 Product Name:   Adaptive Server Enterprise Product Component:   InstallShield Status:   Closed OS:   Windows XP Original Version:   15.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 Oct 2008 Fixed Description Running the installer with "-options-template" switch generates an incomplete options file.

CR:466570

CR Number:   466570 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.1 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 23 Apr 2007 Fixed 23 Apr 2007 Fixed 23 Oct 2007 Fixed Description In rare circumstances the error 206 raises when executing a query with joins and group by.

CR:466578

CR Number:   466578 Product Name:   Sybase ETL Product Component:   Template Status:   Closed OS:   Windows XP Original Version:   4.2.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 24 Jul 2007 Fixed Description Problem: Tables are created with columns having the not null column property when connecting to IQ using ODBC. This is the default for ODBC. This is not the default when connecting using Sybase Open Client causing many of the created projects to fail. Resolution: The column properties were corrected for this release.

CR:466581

CR Number:   466581 Product Name:   Sybase ETL Product Component:   Template Status:   Closed OS:   Windows XP Original Version:   4.2.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 26 Jul 2007 Fixed Description Problem: Migrating a Database from MS SQL SERVER to IQ included a table with a column named "date". The table was created successfully but the load failed. Resolution: All column names are now quoted by default.

CR:466584

CR Number:   466584 Product Name:   Sybase ETL Product Component:   Template Status:   Closed OS:   Windows XP Original Version:   4.2.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Oct 2008 Fixed Description Problem: When migrating data from ASE to IQ and using the 'template' option data types are not mapped correctly. Workaround: This can be avoided by not using the 'template' option. If migration projects are created by hand, using the 'Add destination table from input...' option, the tables get closer to what they need to be and the user can fine tune the column types.

CR:466586

CR Number:   466586 Product Name:   Sybase ETL Product Component:   Template Status:   Closed OS:   Windows XP Original Version:   4.2.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 Nov 2008 Fixed Description Problem: Cannot migrate ASE image columns to Sybase IQ. Resolution: Added secondary LOB file loading support to the DB Bulk load Sybase IQ component. To use this new functionality, add the following to the 'iq_loader' section of the runtime INI file (GridNode.ini | Default.ini): use_secondary_LOB_files=true locallobdir=[directory location to stage the LOB files, relative to the ETL runtime] remotelobdir=[directory location to stage the LOB files, relative to the IQ runtime]

CR:466589

CR Number:   466589 Product Name:   Sybase ETL Product Component:   Template Status:   Closed OS:   Windows XP Original Version:   4.2.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 27 Jul 2007 Fixed Description Problem: Sybase ETL is not maintaining the owner's name on tables. When loading tables from Oracle and MS SQL Server the tables were created with the format OWNER_TABLENAME instead of OWNER.TABLENAME. Resolution: The Template wizard now contains a new "Preserve schema/owner" check box for specifying the destination table name. If the check box is set then the original owner and table name is used. The user must verify that the specified destination schema exists. The Template wizard additionally contains a new option to store SQL scripts to be executed before the destination data model will be created.

CR:466590

CR Number:   466590 Product Name:   Sybase ETL Product Component:   Template Status:   Closed OS:   Windows XP Original Version:   4.2.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 22211 17 Sep 2007 Fixed Description Problem: In the Sybase ETL projects the load scripts and data need to have both column and record delimiters. Without these Sybase IQ runs the load serially (using only one CPU) versus in parallel. Resolution: The load script and column of data are delimited by TAB(0x09), records are delimited by LF(0x0a).

CR:466592

CR Number:   466592 Product Name:   Sybase ETL Product Component:   Template Status:   Closed OS:   Windows XP Original Version:   4.2.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12052 31 Jul 2007 Fixed Description Problem: In the Sybase ETL projects the load scripts need to use unique column delimiters when loading text data. Resolution The column delimiter was changed to '|@#&' to be unique.

CR:466609

CR Number:   466609 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) 27 Jun 2007 Reservation Made 17 Mar 2008 Fixed 25 Apr 2011 Fixed 17 May 2011 Fixed Description Repartitioned exchange can cause poor performance and in some cases we do not need to incur that performance penalty. Instead, it can be handled during a selective index scan, provided the column on which the data needs to be partitioned is part of the index.

CR:466623

CR Number:   466623 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) 21 May 2007 Fixed Description select-into with subquery on union view may fail with error 225 (Cannot run query--referenced object (name NAME NOT RECOVERABLE) dropped during query optimization.)

CR:466677

CR Number:   466677 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) 15 May 2007 Fixed Description New feature to pass UDFs (user-defined functions) to remote servers via CIS

CR:466687

CR Number:   466687 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Windows W2k Original Version:   15.0.1 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 03 May 2007 Fixed 03 May 2007 Fixed 16 Oct 2007 Fixed Description A query could return illegal duplicate rows if it contains a SELECT DISTINCT both in the SELECT clause of a query block and also in the SELECT clause of either a derived table or a view which are directly part that query block's FROM cluase.

CR:466723

CR Number:   466723 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) 29 May 2009 Duplicate Description Feature request for a new global variable @@errormessage that would contain the complete text, including variable information, of the most recent error messages sent to the client

CR:466801

CR Number:   466801 Product Name:   Sybase ETL Product Component:   pEngine Status:   Closed OS:   Windows 2003 Original Version:   4.2.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 09 Oct 2007 Not a Bug 11 Jan 2008 Workaround Description Problem: Sometimes a Grid Node can't be found by the engine Manager even though it is valid. Resolution: The engine can be added manually and it will work successfully. Workaround Description  The UDP broadcasts and packets are not essentially necessary if you already know it is running. If you manually register the GridNode in the user interface it will be used for executing projects as long as it is reachable on the TCP port. Even if the engine monitor lists it as offline or unreachable.

CR:466850

CR Number:   466850 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   To Be Determined Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Support xml namespaces

CR:466855

CR Number:   466855 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   all Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 May 2007 Fixed 15 Jun 2007 Fixed Description Previously ASE Plug-in and Interactive SQL's Connect dialog showed Find button by default. (Find button is used for discovering servers.) The button is now only visible when user enables it, by selecting the check box "Enable server discovery" on Server Discovery page of Settings dialog (click Settings button on Connect dialog), or ASE Plug-in Preferences dialog (right click ASE Plug-in and select Properties menu item). The "Enable server discovery" setting also affects the results on Servers details panel, i.e. ASE Plug-in will only discover servers if the setting is enabled.

CR:466857

CR Number:   466857 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   all Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 07 Jul 2008 Fixed Description ASE Plug-in and DBISQL's Connect Dialog now remembers five recently connected servers by default. The recently connected servers are listed first in the "Server names:" drop-down, separated with the rest of the servers by a line. The number of remembered servers can be adjusted and the server names can be cleared by using the related settings on Settings Dialog. (Click "Settings" button to bring up the dialog.)

CR:466986

CR Number:   466986 Product Name:   Adaptive Server Enterprise Product Component:   DDLGen Status:   Closed OS:   all Original Version:   12.5.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 01 May 2007 Fixed 03 May 2007 Fixed 09 Oct 2007 Fixed Description DDLGen fails in some circumstances to generate DDL for a table, where permissions have been granted on table columns with error P12: Critical internal application error occured.

CR:466992

CR Number:   466992 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15 Jun 2007 Fixed Description Under some circumstances a query that involves "equals to" clauses with expressions containing explicit NULL values, parameters or local variables and it is executed inside a stored procedure could return incorrect results in the rare case that ANSINULL option changes after the stored procedure was compiled, i.e. procedure is not recompiled. Workaround Description  Create the procedure "WITH RECOMPILE" option or execute the procedure "WITH RECOMPILE" clause.

CR:466998

CR Number:   466998 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15 Jun 2007 Fixed Description Under some circumstances incomplete results could be returned when executing a query with a join on an expression which involves local variables and ANSINULL option is OFF.

CR:467000

CR Number:   467000 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 Apr 2007 Fixed 28 Apr 2007 Fixed 13 Oct 2007 Fixed Description When outer joins are used and there is an equi-join outside the scope of the ON clause, in which one of the operands is an expressions and the other operand is a single attribute of the table which is the inner table of the outer join, then there is a possibility of an incorrect answer. An example would be the following select * from t2 left join t1 on c2<c1 where c1=c2-1 go

CR:467010

CR Number:   467010 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) 02 Jul 2007 Fixed Description When matching up cached statement in statement cache, ignore white spaces.

CR:467014

CR Number:   467014 Product Name:   Adaptive Server Enterprise Product Component:   InstallShield Status:   Closed OS:   Windows XP Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 06 Aug 2007 Fixed 09 Oct 2007 Fixed Description management is misspelling in the string "Sybase mangement stored procedures" at the configuration panel during installation.

CR:467016

CR Number:   467016 Product Name:   Adaptive Server Enterprise Product Component:   MDA/Monitoring Tables Status:   Closed OS:   all Original Version:   12.5.4 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 05 Jan 2010 Fixed 28 Jan 2010 Fixed Description In rare circumstance, ASE might report invalid StartTime, EndTime and CpuTime in monSysStatement.

CR:467035

CR Number:   467035 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   12.5.4 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 27 Apr 2007 Not a Bug Description Wrong results may occur when subquery contains NULL values Workaround Description  Modified query to exclude NULLs in the subquery result set.

CR:467036

CR Number:   467036 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   Linux Original Version:   15.0.1 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Error 7215 may be raised at ASE startup if XP Server is registered. Workaround Description  This error is harmless. Please ignore it.

CR:467039

CR Number:   467039 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 Feb 2008 Fixed Description Password complexity options should be in sync between primary and companion servers when ASE is configured for high availability.

CR:467044

CR Number:   467044 Product Name:   Adaptive Server Enterprise Product Component:   InstallShield Status:   Closed OS:   Windows W2k Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 27 Apr 2007 Fixed 27 Apr 2007 Fixed Description localization errors are outputted when configuring servers during installation

CR:467134

CR Number:   467134 Product Name:   Adaptive Server Enterprise Product Component:   optdiag Status:   Closed OS:   all Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 07 Apr 2009 Fixed Description Enhance request for optdiag tool to have GUI mode or option for database name , table name in command line mode.

CR:467148

CR Number:   467148 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Windows XP Original Version:   15.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 May 2007 Fixed Description ASE returns error 594 on cursor update statement with outer join Workaround Description  Drop the column list after the "FOR UPDATE" statement.

CR:467149

CR Number:   467149 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.1 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 07 Jun 2007 Fixed 12 Jul 2007 One-off Provided 12 Oct 2007 Fixed Description An error 15412 or other memory allocation fail-related errors may raise when executing sql statement involving encrypted columns features.

CR:467253

CR Number:   467253 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   12.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15 May 2007 Fixed 14 Mar 2008 Not a Bug Description When executing stored procedure a new timestamp value is not assigned after performing UPDATE query on a table created in the same procedure. Similary timestamp returned after calling tsequal() is also incorrect.

CR:467296

CR Number:   467296 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.4 ESD#5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15 Oct 2007 Presently Not Targeted For Any Future Release Of This Product 05 Jul 2007 Consult Complete 28 Jun 2007 Fixed Description Add an optional parameter to 'dbcc checktable' to specify the dbid, thus allowing 'dbcc checktable' to be run on offline databases.

CR:467400

CR Number:   467400 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.0.1 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 May 2007 Fixed 04 May 2007 Fixed Description When HA primary and companion servers are established in failover mode and sp_locklogin attempts to lock a login account, an HA consistency error is reported.

CR:467425

CR Number:   467425 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) 26 Jul 2007 Fixed Description When user config a server, there is no response when user click the browser button to navigate the ASE's location.

CR:467447

CR Number:   467447 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) 13 May 2007 Fixed 06 Jun 2007 Fixed 29 Jun 2007 One-off Provided 06 Nov 2007 Fixed Description Since ASE 12.5.4, 923 errors, "User <user> not allowed in database '<database>' - only the owner of this database can access it" and 937 errors, "Database '<database>' is unavailable. It is undergoing LOAD DATABASE" may be reported unnecessarily. Workaround Description  Re-code applications to ignore these errors.

CR:467485

CR Number:   467485 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   12.5.4 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 Jun 2007 Fixed 13 Mar 2008 Not a Bug 13 Mar 2008 Not a Bug Description On linux, ASE encounters errors if traceflag 1649 is enabled at runtime and not at server startup. Also ASE hits a stacktrace if traceflag 1649 is used on platforms where 1649 is not supported. Workaround Description  Turn off trace flag 1649.

CR:467488

CR Number:   467488 Product Name:   Adaptive Server Enterprise Product Component:   Job Scheduler Status:   Closed OS:   Solaris Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Jul 2007 Fixed 16 Oct 2007 Fixed Description If the port number > 32767 is used for the Job Scheduler connection, the connection does not succeed and following error is logged in the errorlog : kernel -> JS: Failed to connect on socket. And hence, the Job Scheduler fails to come up. Workaround Description  Use a port number less than 32768.

CR:467496

CR Number:   467496 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   Windows XP Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 08 May 2007 Fixed Description Title in Create Job Wizard does not show the name of the template selected as the basis for the job.

CR:467500

CR Number:   467500 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) 23 Jun 2008 Fixed Description A SELECT query with GROUP BY ALL and a scalar subquery like (SELECT 1) may report a signal 11 with a stack trace containing the module 'NormalizeScalar'.

CR:467526

CR Number:   467526 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 Oct 2007 Fixed Description Stacktrace could happen during execution if the query has a correlated subquery under OR and the OR predicate's transformation could render the subquery part of the always-TRUE conjunct (being "redundant"). For example, (a=1) or ((a=1) and (subq)) could be transformed into the equivalent (a=1) without the subq evaluation.

CR:467548

CR Number:   467548 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) 11 Jun 2007 Fixed Description Queries containing 'order by' or 'group by' clause may run into syntax error if the table or column name following 'order by' or 'group by' is 'range','list','hash', or 'roundrobin'. The workaround is adding '()' around the table/column name following 'order by' or 'group by'. Workaround Description  Add '()' around the table/column name following 'order by' or 'group by'.

CR:467566

CR Number:   467566 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 Aug 2008 Fixed 25 Nov 2008 One-off Provided Description Specifying an abstract plan (AP) with any query will cause the query not to be stored in the statement cache.

CR:467629

CR Number:   467629 Product Name:   Adaptive Server Enterprise Product Component:   sybmon Status:   Closed OS:   NA Original Version:   15.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 07 Apr 2008 Fixed Description While running 'who' command in sybmon, if pss is lock sleeping and blocker thread is on remote instance, then we were reporting it as blocked by itself. This erroneous self-deadlock reporting is corrected in this CR. If pss is blocked by remote thread, then now it as reported as 'Blocked by spid: (Remote spid - Unknown)'

CR:467731

CR Number:   467731 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.4 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 26 Jul 2007 Presently Not Targeted For Any Future Release Of This Product 06 Jul 2007 Fixed Description If ASE tries to move more buffers between two pools than the source pool size, the error 852 will be returned but it can incorrectly print the message 'Invalid pointer param number 4, pointer value 0x00000012' instead of the cache name.

CR:467744

CR Number:   467744 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 Oct 2008 Not reproducible with latest version of the product available as of Resolution Date Description The error 7128, "Text pointer value 0x120200000000000000000000490e0000 references a data page which is no longer allocated." can be raised when deleting a row on a table based on a subquery that has a join on the same table. Workaround Description  Avoid duplicating the external table in the join in the subquery.

CR:467752

CR Number:   467752 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) 03 Jun 2007 Fixed Description UPDATE STATISTICS on proxy table via import statistics does not work for the bigint, unsigned smallint, unsigned int and unsigned bigint datatypes.

CR:467798

CR Number:   467798 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) 07 Jun 2007 Fixed 15 Jun 2007 Reservation Made Description The server may crash with recursive failure and stack overflow upon receiving error 603, "There are not enough system session descriptors available to run this query.Raise the value of the configuration parameter 'number of aux scan descriptors'or retry your query later."

CR:467819

CR Number:   467819 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description When sp_helpconfig is run with the parameter 'max query parallel degree', the description for 'max parallel degree' is returned.

CR:467830

CR Number:   467830 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) 25 Jun 2007 Fixed 11 Jul 2007 Fixed Description Include the column 'StatModDate' in the space usage archive table, to track the last time statistics were modified for each table or index whose space usage data is being archived. Workaround Description  Archive tables created with 1502GA will not be properly usable with installmaster from 1502 ESD#1. A simple workaround is to run the following command, prior to using sp_spaceusage in "archive" mode with ESD#1: ALTER TABLE <archive table name> ADD StatModDate datetime NULL

CR:467841

CR Number:   467841 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX Original Version:   12.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15 May 2007 Fixed 22 Aug 2007 Fixed Description The message "current process ... infected with 11" may be reported in module 'dol_row_delete' during the execution of a DELETE command from a Data Only Locked table. The modules 'dol_delete' and 'row_delete' would also be reported in the stack trace in the error log.

CR:467848

CR Number:   467848 Product Name:   Adaptive Server Enterprise Product Component:   InstallShield Status:   Closed OS:   all Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 May 2007 Fixed 23 May 2007 Fixed Description Due to problems installing Infomaker on Windows 20003 from the PC-Client autorun menu, the InfoMaker install must now be run separately. The autorun menu has been changed to display instructions for launching the Infomaker installer.

CR:468027

CR Number:   468027 Product Name:   Adaptive Server Enterprise Product Component:   InstallShield Status:   Closed OS:   NA Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 09 May 2007 Fixed Description Only the first license server in a Three Server Redundant configuration can be started. This is because the sysam script checks whether a License Server is UP but does not differentiate between server names in a Three Server Redundant configuration so it assumes all servers are UP as soon as the first is started. Workaround Description  Change the command that checks whether the server is UP to also grep for the hostname. I.e. change the line: `${bindir}/lmutil lmstat -c ${licsrc} | grep 'license server UP' > /dev/null 2>&1` to OSHOST="`uname -n`" `${bindir}/lmutil lmstat -c ${licsrc} | grep 'license server UP' | grep ${OSHOST} > /dev/null 2>&1`

CR:468077

CR Number:   468077 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   RH Linux Original Version:   15.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Dec 2007 Fixed 23 Dec 2007 Not a Bug Description LDAP UA has been supported on ibmplinux.

CR:468079

CR Number:   468079 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) 29 Jan 2008 Fixed Description Enable Web Service feature on winx64.

CR:468099

CR Number:   468099 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.1 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 10 May 2007 Fixed 10 May 2007 Fixed 14 Oct 2007 Fixed Description Possible wrong result when there is a mismatch datatype comparison underneath a CASE expression and an implicit CNVT node is needed there.

CR:468149

CR Number:   468149 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Microsoft Windows Original Version:   15.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 May 2007 Fixed Description A performance degradation may be noticed while using java UDFs with internal jdbc calls.

CR:468180

CR Number:   468180 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Mar 2009 Work as design Description ASE sporadically fails to return result sets Workaround Description  Possibly add dbsetversion(DBVERSION_100) to force the application to use TDS 5.0.

CR:468188

CR Number:   468188 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   To Be Determined Fixed Version Build Resolution Date Closure Code (If Appropriate) 25 May 2007 Fixed 14 Mar 2008 Fixed Description SELECT INTO query with UNION may not execute correctly if the query plan generated for the parallel execution will be adjusted to the serial execution.

CR:468190

CR Number:   468190 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.0.2 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 23 May 2007 Fixed Description When there are multiple sargs from which to choose , then sometimes a non-equisarg would get chosen over an equisarg, which is usually not the best choice. select * from r,s where (r.a = s.a OR r.b = s.b) and r.a >= 5 In the above example, or general OR optimization, we have a choice between using "r.a = s.a" vs. "r.a > 5" and in some cases we chose "r.a > 5" for the index lookup on "r.a", which is usually not correct.

CR:468277

CR Number:   468277 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UX Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 May 2007 Fixed 21 May 2007 Diagnostic Provided 07 Jun 2007 Fixed 23 May 2007 Fixed Description The message "Current process ... infected with signal 11 (SIGSEGV)" may be reported in module 'memfreeheap' during the execution of an ALTER TABLE to change the lock scheme of a table from 'allpages' to 'datarows/datapages'. The modules 'altertab' and 'alt_lock_change' would also be reported in the stack trace in the error log.