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

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

CR:301914

CR Number:   301914 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 09 Jan 2003 Fixed 25 Feb 2003 Fixed Description Addition of a new command "dbcc tune(loglicenseuse, 0)" for logging "license use" information into syblicenseslog.

CR:301924

CR Number:   301924 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 09 Dec 2002 Fixed 09 Dec 2002 Fixed 10 Dec 2002 Fixed Description When a database is marked read only or in standby access mode, an attempt to execute a DROP TABLE command fails to report either a 3906 or a 3944 error; "Attempt to BEGIN TRANSACTION in database '<value>' failed because...".

CR:301935

CR Number:   301935 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 28 Apr 2003 Presently Not Targeted For Any Future Release Of This Product 18 Mar 2005 Duplicate Description Arithemtic overflow error occurs when sp_configure is used to configure max memory >= 2G. Target Version  12.5.1 Review Status  Reviewed March 2003. Fix is targeted (but not committed) for the ASE 12.5.1 release. Workaround Description  Specify in page size like sp_configure "max memory",2621440(5G)

CR:301961

CR Number:   301961 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Microsoft Windows NT Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 23 Dec 2002 Fixed 24 Dec 2002 Fixed 18 Feb 2003 Fixed Description Slight improvement to information output to error log when ASE encounters an unhandled exception on the NT platform

CR:301971

CR Number:   301971 Product Name:   Adaptive Server Enterprise Product Component:   upgrade Status:   Closed OS:   Solaris Original Version:   12.5.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 Dec 2002 Fixed 19 Dec 2002 Fixed Description Upgrading to ASE 12.5 may fail if the SYSSTATISTICS table has forwarded rows. The message "Database '<value>': beginning upgrade step [ID 1301]: Upgrade colidarray in sysstatistics to 2-byte column IDs" would be followed by a stack trace in the error log showing modules 'st_upgrade_statistics', 'update' and 'dol_update'. Workaround Description  bcp out and in the sysstatistics data. OR Run "reorg forwarded_rows sysstatistics" before upgrading.

CR:301972

CR Number:   301972 Product Name:   Adaptive Server Enterprise Product Component:   backup server Status:   Closed OS:   Microsoft Windows NT Original Version:   12.5.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 27 Feb 2003 Fixed 06 Mar 2003 Fixed 18 Jul 2003 Fixed 18 Jul 2003 Fixed Description On Windows platform, DUMP and LOAD commands leak file handles which can accumulate over a series of dump/loads, with the backupserver eventually running out of file handles and reporting the error "nl__write_defer: write failed on socket 1: Insufficient quota to complete the requested service".

CR:301982

CR Number:   301982 Product Name:   Adaptive Server Enterprise Product Component:   xpserver Status:   Closed OS:   HP-UX Original Version:   12.5.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Dec 2002 Fixed 03 Jan 2003 Fixed 29 Jan 2003 Fixed Description XPSERVER: XP server may generate a core file when the 'esp unload dll' configuration option is set to 1. Workaround Description  Set 'esp unload dll' ASE configuration option to 0. The code in error will not be executed.

CR:302065

CR Number:   302065 Product Name:   Adaptive Server Enterprise Product Component:   omni Status:   Closed OS:   HP-UX Original Version:   12.0.0.6 Fixed Version Build Resolution Date Closure Code (If Appropriate) 09 Jun 2005 EOL'd version. Not to be Fixed. 12 Apr 2006 Fixed 13 Apr 2006 Reservation Made 12 Apr 2006 Fixed 13 Apr 2006 Fixed 13 Apr 2006 Fixed Description New configuration property 'cis idle connection timeout' has been implemented. The value of this property represents seconds. However, the granularity of the timeout is determined by the housekeeper, which wakes up roughly every minute to perform its housekeeping chores. One of the new chores is to check for CIS connections that have been idle for a time equal to or greater than the configured timeout value. If that is the case, these connections are dropped, if no transaction is pending for the thread that owns the connection.

CR:302072

CR Number:   302072 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX Original Version:   12.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 03 Dec 2002 Duplicate Description Run sp_setreptable on large table with text/image column will take a long time and put exclusive lock on the table.

CR:302099

CR Number:   302099 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 06 Dec 2002 Fixed 06 Dec 2002 Fixed 06 Dec 2002 Fixed 06 Dec 2002 Fixed 13 Dec 2002 Fixed Description A 103 error, "The identifier that starts with '<identifier>' is too long. Maximum length is 30", is reported when a statement with multiple keywords is executed and the total size of all the double and triple keywords within the command exceeds 30 characters.

CR:302115

CR Number:   302115 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Dec 2002 Fixed 18 Apr 2003 Fixed 20 Dec 2002 Fixed 13 Jan 2003 Fixed Description Provides Java samples to illustrate the usage of SQL-to-XML and XML-to-SQL mapping functionality, as specificed by the SQLX standards (part of ANSI SQL committe). The samples are available under $SYBASE/ASE-12_5/samples/JavaSql-R1 directory.

CR:302123

CR Number:   302123 Product Name:   Adaptive Server Enterprise Product Component:   mscs_ha Status:   Closed OS:   Microsoft Windows Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 06 Jan 2003 Fixed 02 Jan 2003 Fixed 12 Feb 2003 Fixed 05 Sep 2003 Fixed Description ASE on windows NT will not listen on the virtual IP address in a Microsoft NT cluster system. It listens on the local node's address instead. Target Version  12.5.0.3 Review Status  Reviewed March 2003. CR has been fixed in the 12.5.0.3 IR release. Workaround Description  Set the client sql.ini and ODBC connections to point to the physical IP of the current Node in the cluster (so if failover occurs, we will have to manually change these to point to the secondary node) or use the virtual host name associated with the

CR:302165

CR Number:   302165 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 26 Apr 2003 Fixed Description As the size of the default data cache increase the recovery time for the database becomes slower

CR:302167

CR Number:   302167 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX 5.1 Original Version:   12.5.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16 Dec 2002 Fixed 05 Mar 2003 Fixed Description ASE core dumps on startup if TZ (timezone) environment variable is set to an invalid value. Invalid values generaly involve a standard timezone setting (GMT, CST, etc) with an offset exceeding 12 or 24 hours (depending on platform).

CR:302228

CR Number:   302228 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   NA Original Version:   12.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 Jan 2003 Presently Not Targeted For Any Future Release Of This Product 02 Jan 2003 Fixed 12 Mar 2003 Fixed Description When running with double-byte character sets, the utility cpre raises M_SYNTAX_PARSE error during precompilation.

CR:302233

CR Number:   302233 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.0.0.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15 Nov 2003 Presently Not Targeted For Any Future Release Of This Product Description Implement a mechanism to detect a loop during recovery that allows recovery to be aborted at some point so that other databases can be recovered. Target Version  12.5.1 Review Status  Reviewed March 2003. Fix is targeted (but not committed) for the ASE 12.5.1 release.

CR:302264

CR Number:   302264 Product Name:   Adaptive Server Enterprise Product Component:   Historical Server Status:   Closed OS:   Solaris Original Version:   12.5.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 Jul 2007 Insufficient priority to fix Description 1. Automate the process of analyzing the server performance parameters. 2. Automate the process of deleting old inactive sessions & views. 3. Have historical server put the data directly into a table instead of a text file

CR:302276

CR Number:   302276 Product Name:   Adaptive Server Enterprise Product Component:   omni Status:   Closed OS:   all Original Version:   12.5.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Dec 2002 Fixed 11 Dec 2002 Fixed 10 Dec 2002 Fixed 17 Dec 2002 Fixed 17 Dec 2002 Fixed Description An erroneous 103 error may be reported by CREATE DATABASE or ALTER DATABASE that uses the FOR PROXY_UPDATE option and either a table name, owner name or column name within the proxy database has exactly 28, 29 or 30 characters. Workaround Description  A good design practice is to limit all identifiers to 28 bytes.

CR:302300

CR Number:   302300 Product Name:   Adaptive Server Generic Docs Product Component:   System Administration Guide Status:   Closed OS:   all Original Version:   12.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 07 Feb 2003 Presently Not Targeted For Any Future Release Of This Product Description ha_role whose uid is 16391 is not documented as a sybase role in 12.0 doc Target Version  12.5.1 Review Status  Reviewed March 2003. Targeted for next release of documentation (12.5.1).

CR:302339

CR Number:   302339 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   Solaris Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Sep 2003 Fixed 10 Dec 2002 Fixed 07 Nov 2005 Not a Bug Description Corrected scjview script to save the log to sc_error.log if exit status is not normal

CR:302414

CR Number:   302414 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Dec 2002 Fixed 18 Dec 2002 Fixed Description Database creation or initializing a device through disk init may fail on a file system or raw device when the size is more than 2G bytes on Linux Advanced Server 2.1.

CR:302422

CR Number:   302422 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Microsoft Windows NT Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 09 Dec 2002 Fixed 05 Dec 2002 Fixed 09 Dec 2002 Fixed Description ASE running on NT may get into a hung state, when a session that has SSL enabled is killed.

CR:302428

CR Number:   302428 Product Name:   Adaptive Server Generic Docs Product Component:   Troubleshooting:Error Messages Status:   Open OS:   all Original Version:   12.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description dbcc checkalloc may report error 2521 with "object id in extent=0". Revise writeup on Error 2521 in TSG on how to handle this.

CR:302438

CR Number:   302438 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.0.0.6 Fixed Version Build Resolution Date Closure Code (If Appropriate) 24 Feb 2003 Fixed Description A 940 error will be reported when the builtin OBJECT_NAME(<objid>, <dbid>) is invoked such that the <objid> value is for a master database-only system table, the <dbid> value is not '1' and the builtin is invoked from a database other than that given by <dbid>. Workaround Description  select object_name(30)

CR:302626

CR Number:   302626 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   NA Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 Dec 2002 Fixed 18 Dec 2002 Fixed Description When Unicode conversion is on and data may expand from client's character set (e.g. iso_1) to server's charset (e.g. utf8), error 7153 will be raised when sending runtime values to image column.

CR:302696

CR Number:   302696 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 06 Jan 2003 Fixed 03 Jan 2003 Fixed 04 Mar 2003 Fixed Description Under heavy load, in multi-engine system, Rep Agent processes encounter "timeslice" errors in usctconengine(). Target Version  12.5.0.3 Review Status  Reviewed March 2003. Fixed in 12.5.0.3. Fix will also be included in ASE 12.5.1.

CR:302877

CR Number:   302877 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   12.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Customer would like to see Sybase provide the following scripts. They have been asking for such scripts for several years now and would like to see some utilitarian scripts to help reduce manual effort with these tasks. 1. Solaris /etc/init.d/sybase script to start and stop all servers. 2. Script to do master database critical table BCPs, take snapshot of current configuration, and dump the master database. 3. System procedure to run "update statistics" on all user tables.

CR:302892

CR Number:   302892 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   Solaris Original Version:   12.0.0.6 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Introduce a switch to display server-wide or database specific details for sp_displayaudit Target Version  To Be Determined Review Status  Reviewed March 2003. Fix is targeted (but not committed) for ASE 15.0 release. Workaround Description  Currently sp_displayaudit is executed in each database.

CR:302979

CR Number:   302979 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.0.0.6 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Feb 2003 Fixed 24 Feb 2003 Fixed Description A 10367 error will be incorrectly raised when a user with permission to SELECT a grantable built-in (SET_APPCONTEXT, GET_APPCONTEXT, RM_APPCONTEXT or LIST_APPCONTEXT), tries to SELECT them from within a stored procedure owned by another user who has not been explicitely granted to do so. Workaround Description  To grant select on set_appcontext to public (cruiz) In fact that works, but it should be enough with granting it to the procedure owner, in this case the dbo.

CR:303045

CR Number:   303045 Product Name:   Adaptive Server Enterprise Product Component:   syconfig - PC Status:   Closed OS:   Microsoft Windows NT Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 25 Jul 2003 Fixed Description The sybatch sample resource file does not include the sqlsrv.server_page_size attribute Target Version  12.5.1 Review Status  Reviewed March 2003. Fix is targeted (but not committed) for the ASE 12.5.1 release.

CR:303080

CR Number:   303080 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.0.0.6 Fixed Version Build Resolution Date Closure Code (If Appropriate) 29 Jan 2003 Fixed 13 Feb 2003 Fixed 24 Feb 2003 Fixed Description In rare circumstances, the message "current process infected with 11" may be reported in the error log together with a stack trace that includes the modules 'dol_qualrow' and 'dol__get_lock' when a data only locked table is queried. Alternatively, a 12300 error, "Internal error: in table '<value>', database <value>, the forwarded row (<value>, <value>) pointed to by (<value>, <value>) is invalid", may be reported. Workaround Description  Use all page locked tables instead of dol tables.

CR:303081

CR Number:   303081 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15 Jan 2003 Not a Bug Description Add an sp_configure option that will allow a user with OPER role to dump databases that are in "DBO Use Only".

CR:303178

CR Number:   303178 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 28 May 2003 Fixed 27 Jun 2003 Fixed Description If an engine offline request causes the engine to enter the "dormant" state, and the entire server is shutdown while that engine is still in the dormant state, the unix process corresponding to the dormant engine may still be present after shutdown.

CR:303223

CR Number:   303223 Product Name:   Adaptive Server Enterprise Product Component:   omni Status:   Closed OS:   all Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Dec 2002 Fixed 17 Dec 2002 Fixed Description In ASE 12.5 a feature was implemented that filters rows from proxy tables mapped to an RPC so that the result set is consistent with predicates in the where clause. This has caused differences in behavior and customers have asked for the old behavior. A trace flag (11225) has been added which disables the filtering.

CR:303270

CR Number:   303270 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 27 Oct 2003 Presently Not Targeted For Any Future Release Of This Product 12 Jan 2004 Fixed Description When a SELECT INTO command fails during the data insert phase in the given target table, then some data is mistakenly left into it, although the target table's creation cannot be undone at that stage. Workaround Description  N/A

CR:303319

CR Number:   303319 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   NA Original Version:   voyager Fixed Version Build Resolution Date Closure Code (If Appropriate) 04 Apr 2003 Fixed Description In ASE, give Sybase Central the ability to display the Quiesce Database tag for any database in the Quiesce Database hold state.

CR:303371

CR Number:   303371 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UX Original Version:   12.5.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 30 Jun 2006 Presently Not Targeted For Any Future Release Of This Product Description Prevent QUIESCE DATABASE to become a deadlock victim as QUIESCE DATABASE is often used in conjunction with backup strategies. Target Version  12.5.1 Review Status  Reviewed March 2003. Fix is targeted (but not committed) for the ASE 12.5.1 release.

CR:303408

CR Number:   303408 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   NA Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 06 Mar 2003 Fixed Description The CountersCleared column of the monState monitoring table is now updated with the date that the monitor counters were last cleared by sp_sysmon.

CR:303423

CR Number:   303423 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 24 Feb 2003 Fixed 07 Mar 2003 Fixed Description The message "Msg 225, Level 16, State 1 Cannot run query--referenced object (name NAME NOT RECOVERABLE) dropped during query optimization." maybe reported when executing a SELECT INTO statement using views in the FROM clause together with multiple UNION clauses and a GROUP BY clause. Workaround Description  See /remote/tt_evn/10888000s/10888551/pseinfo-12/Repro/sql_script-new, replace the SELECT INTO query with two queries: 1. use a select into query to create an empty table, then use insert select to put the data into the new table.

CR:303508

CR Number:   303508 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Microsoft Windows NT Original Version:   12.5.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16 Dec 2002 Fixed 11 May 2003 Fixed 05 Feb 2004 Fixed Description Assertion failure in ct_con_props->ct_api_constatus() when RepAgent is shutting down. Occurs only with diagserver and diag OCS libraries. Stacktrace will show ra_drop_csconn()->ct_con_props()->com_bomb().

CR:303554

CR Number:   303554 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Microsoft Windows NT Original Version:   12.0.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 21 Mar 2003 Fixed 16 Apr 2003 Fixed Description On Windows NT platforms as of 12.0.0.3 ESD 3, the Windows NT performance monitor (perfmon.exe) is unable to list counters from any configured ASEs.

CR:303572

CR Number:   303572 Product Name:   Adaptive Server Enterprise Product Component:   xpserver Status:   Closed OS:   AIX Original Version:   12.5.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Jan 2003 Fixed 13 Jan 2003 Fixed 13 Jan 2003 Fixed 21 Feb 2003 Fixed Description xpserver versions 12.5.0.2 and higher for 32-bit AIX may fail to run if the full OpenServer SDK has not been installed in $SYBASE/$SYBASE_OCS. Attempting to run xpserver fails in exec() reporting "Cannot load program xpserver because of the following errors: " followed by the message "Dependent module libsrv.so could not be loaded". Target Version  12.5.0.3 Review Status  Reviewed March 2003. CR is fixed in the ASE 12.5.0.3 IR release. Workaround Description  Run older xpserver, or try intalled the full connectivity sdk.

CR:303579

CR Number:   303579 Product Name:   System Admin Guide Product Component:   System Administration Guide Status:   Closed OS:   NA Original Version:   4.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 5.0 08 Dec 2003 Fixed Description Request for more explicit documentation over how the inclusion of a JAR file in the java/lib directory will be treated in terms of class loaders, to the point where behavior may differ from placing the implementation in the java/classes directory. Additionally, the documentation should include recommendations for when a JAR file should be in java/lib versus in the java/classes hierarchy.

CR:303590

CR Number:   303590 Product Name:   Sybase InstallShield Product Component:   InstallShield Status:   Closed OS:   Generic Original Version:   3.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 Dec 2002 Fixed 3.0 17 Dec 2002 Fixed 3.0 17 Dec 2002 Fixed 3.0 17 Dec 2002 Fixed 3.0 17 Dec 2002 Fixed 3.0 17 Dec 2002 Fixed Description The NullPointerException at SunGraphics2D.<init> no longer occurs when clicking the Next button on the Product Selection panel of a Suite.

CR:303695

CR Number:   303695 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   NA Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Dec 2002 Fixed 20 Dec 2002 Fixed Description The error 225 will be raised if a SELECT INTO statement contains an ORDER BY with a column that does not appear in the result select list.

CR:303834

CR Number:   303834 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UX Original Version:   12.5.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Feb 2003 Duplicate Description When a database (D1) has the 'dbo use only' option set, 923 errors are incorrectly reported when stored procedures in another database (D2) are executed by D1.dbo (who is aliased to D2.dbo) and these stored procedures reference tables in D1. Target Version  12.5.1 Review Status  Reviewed March 2003. Fix is targeted (but not committed) for the ASE 12.5.1 release. Workaround Description  Remove 'dbo use only' database option.

CR:303850

CR Number:   303850 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 26 Mar 2003 Fixed Description When executing deeply nested stored procedures (at least 14 levels of nesting with the default stack size), the ASE server may generate a stack trace and the following messages: "Stack overflow detected:" and "Stack guardword corrupted.", and exit.

CR:303886

CR Number:   303886 Product Name:   Adaptive Server Enterprise Product Component:   asecfg Status:   Open OS:   all Original Version:   12.5.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Make a utility that will automatically convert an older version of cfg to a newer version of the cfg when doing a database upgrade. Target Version  To Be Determined Review Status  Reviewed March 2003. Fix is targeted (but not committed) for ASE 15.0 release.

CR:303909

CR Number:   303909 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 Dec 2003 Fixed Description @@sqlstatus values returned by a UNION ALL query having a select <select_list> = hard_coded_value is incorrect Target Version  12.5.1 Review Status  Reviewed March 2003. Fix is targeted (but not committed) for the ASE 12.5.1 release.

CR:303948

CR Number:   303948 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Jan 2003 Fixed 21 Feb 2003 Fixed Description Upgrade to ASE 12.5 will fail if the trace flag 3610 is enabled. The message "Database '<value>': beginning upgrade step [ID 1307]: executing SQL statement (if not exists (select 1 from syscol)" would be followed by 1505 error "Create unique index aborted on duplicate key. Primary key is '<value>'". Target Version  12.5.0.3 Review Status  Reviewed March 2003. This CR is fixed in ASE 12.5.0.3 ESD #1. Workaround Description  Turn off trace flag 3610.

CR:303960

CR Number:   303960 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX Original Version:   12.0.0.6 Fixed Version Build Resolution Date Closure Code (If Appropriate) 08 Apr 2003 Fixed 20 Feb 2003 Fixed Description Running REORG REBUILD on an index of a DATA_ONLY LOCKED table, Error 12323, state 51 may be raised when running REORG REBUILD on an index of a DATA_ONLY LOCKED table. A stack trace will appear in the errorlog with module bt__batchinsert_log_getendpos() and bt__rebldchk_failed().

CR:303993

CR Number:   303993 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 23 Jan 2003 Fixed 19 Feb 2003 Fixed Description Sessions with a 'tempdb_space' resource limit imposed through SP_ADD_RESOURCE_LIMIT may hang in a status of 'MAINTENANCE TOKEN' as shown by SP_WHO. ASE would need to be restarted to alleviate this problem. Target Version  12.5.0.3 Review Status  Reviewed March 2003. CR is fixed in ASE 12.5.0.3 ESD #1. Workaround Description  None except to stop using the tempdb_space limit. Restart the ASE to reset the memory pool and connections will succeed again.

CR:304052

CR Number:   304052 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX Original Version:   12.5.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 May 2003 Fixed 01 Apr 2003 Presently Not Targeted For Any Future Release Of This Product Description A query containing a like clause against a text column will incorrectly return rows where the text column has a value of NULL. This will happen if the row previously contained a non-NULL text value, but has since been updated to NULL.

CR:304071

CR Number:   304071 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   NA Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16 Dec 2003 Fixed Description Sessions may be suspended for an unnecessarily long time while waiting for a QUIESCE DATABASE...HOLD operation to take effect. Workaround Description  Issue a manual checkpoint in each database to be quiesced immediately before issuing the QUIESCE DATABASE.

CR:304152

CR Number:   304152 Product Name:   Adaptive Server Enterprise Product Component:   srvbuild Status:   Closed OS:   Microsoft Windows NT Original Version:   12.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 26 Jul 2004 Fixed Description Syconfig.exe and Sybatch.exe add the Backup and Monitor server entries into the interfaces file when it configures a new Adaptive Server.

CR:304194

CR Number:   304194 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) 29 Jan 2003 Fixed 06 Mar 2003 Fixed Description CIS : An RPC call from a server in one HA cluster to a remote server in another HA cluster fails with error 11216 and 11206

CR:304223

CR Number:   304223 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX 5.1 Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 06 Jan 2003 Fixed Description When connectivity release area is missing the SSL filter shared library, a segmentation violation occurs on outbound CIS connections using SSL. The solution is to ensure that the appropriate SSL filter with driver version is in place in the OCS-12_5/lib directory. Connectivity is fixing library behavior so that an appropriate error message is encountered, instead of a segfault.

CR:304244

CR Number:   304244 Product Name:   Adaptive Server Enterprise Product Component:   backup server Status:   Open OS:   Solaris Original Version:   12.0.0.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description New Feature request: allow backupserver to write check-sum during dump for possible data corruption detection due to hardware problem. Target Version  12.5.1 Review Status  Reviewed March 2003. Fix is targeted (but not committed) for a future ESD of the ASE 12.5.1 release.

CR:304273

CR Number:   304273 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UX Original Version:   12.0.0.6 Fixed Version Build Resolution Date Closure Code (If Appropriate) 09 Apr 2003 Fixed 09 Apr 2003 Fixed 27 Aug 2003 Fixed Description In rare circumstances, the sysaudits_0<n> table may become corrupted if a SHUTDOWN WITH NOWAIT is done at the same time as an audit record is being inserted into the table. Workaround Description  We may be able to avoid this problem by turning OFF auditing before shutting down with nowait. (sp_configure "auditing", 0) However, In HA cluster environment, HP MC ServiceGuard may force ASE to shutdown with nowait when something trouble happens to ASE

CR:304323

CR Number:   304323 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 27 Feb 2003 Fixed 06 Mar 2003 Bundled Request Description When configured with SunCluster3.0 cluster, if monitoring is enabled when the monitor user is not added to ASE, the monitor program fails to start but it doesn't give any error.

CR:304458

CR Number:   304458 Product Name:   Adaptive Server Enterprise Product Component:   backup server Status:   Closed OS:   macosx Original Version:   12.5.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 07 Dec 2003 Duplicate Description dump with compression not working in MacOS X backupserver 12.5.01 (GA). Target Version  12.5.0.3 Review Status  Fixed in 12.5.0.3

CR:304543

CR Number:   304543 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Feb 2003 Fixed 06 Mar 2003 Fixed 26 Feb 2003 Fixed 19 Mar 2003 Fixed 19 Mar 2003 Fixed Description Multi-engine ASE occassionally fails to bring all engines online on Solaris 9. ASE kernel reports "Process <process ID of failed engine process> exited with status 0" in the errorlog followed by the message "current process infected with 11" in the module 'kediagexit' together with a stack trace.

CR:304544

CR Number:   304544 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 28 Feb 2003 Fixed 06 Mar 2003 Bundled Request Description When configured with Suncluster3.0 cluster, if the ha_companion.<server_name> file is not available on secondary node, failover fails with syntax errors like "syntax error at line 13 : `end of file' unexpected" on console screen.

CR:304593

CR Number:   304593 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.0.0.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 26 Mar 2003 Fixed Description sp_sysmon now prints the full date and time when the statistics is cleared and sampled.

CR:304690

CR Number:   304690 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 27 Jan 2004 Fixed Description A variable that is part of an "on" clause raises an error only if the table column has a default.

CR:304695

CR Number:   304695 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   NA Original Version:   12.5.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 Jan 2003 Fixed 21 Feb 2003 Fixed Description DBCC CHECKDB incorrectly checks objects that are not tables.

CR:304774

CR Number:   304774 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 Apr 2009 Insufficient priority to fix Description A feature request for installmaster automatically grant existing permissions.

CR:304778

CR Number:   304778 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15 Nov 2003 Fixed Description Fixed a harmless typo in helpthreshold procedure

CR:304850

CR Number:   304850 Product Name:   Adaptive Server Enterprise Product Component:   FTS SDS Status:   Closed OS:   Solaris Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.5.0.3 09 Jan 2003 Fixed 20 Mar 2003 Fixed Description EFTS: For SOLARIS and NT only, additional vdkLanguages and vdkCharsets have been incorporated into the Enhanced Full-Text Search. Please see the Release Bulletin for more details.

CR:304892

CR Number:   304892 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Mar 2003 Fixed 07 Apr 2003 Fixed 19 Mar 2003 Fixed 07 May 2003 Fixed Description sp_spaceused syslogs, sp_helpsegment "logsegment", and DBCC CHECKTABLE(syslogs) do not report the amount of log space that is reserved for rollback log records. Workaround Description  .

CR:305016

CR Number:   305016 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   Microsoft Windows NT Original Version:   12.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Apr 2012 Presently Not Targeted For Any Future Release Of This Product Description Sybase Central to be used with unified login

CR:305018

CR Number:   305018 Product Name:   Adaptive Server Enterprise Product Component:   omni Status:   Closed OS:   Solaris Original Version:   12.5.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 24 Feb 2003 Fixed 05 Mar 2003 Fixed Description CIS: select from proxy RPC in a stored procedure may not return correct result set.

CR:305035

CR Number:   305035 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 29 Apr 2004 Fixed Description Update two login failure messages when an invalid TDS token is received so that they print the token value that caused the problem

CR:305058

CR Number:   305058 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Jan 2003 Fixed 04 Feb 2003 Fixed Description LOAD DATABASE may fail with error 8201 "Keep count of descriptor (objid=<value>, dbid=<value> was expected to be 1. Instead 2 was found." after error 3121 "Index <value>.<value> (objid=<value>, indid=<value>) may be invalid. It uses CHAR or VARCHAR columns in its key and was created under a different sort order ID (<value>) or charset ID (<value>) than the ones on this server (SortOrd=<value>, CharSet=<value>)." was first raised for a table that has more than one such index. The stack trace will report modules 'lddb_main', 'des_refreshall' and 'des__clean'. Workaround Description  When possible just try: Drop the related indices on the source server. Dump the database again. Load the database on the target server. Online the database. Recreate the indices.

CR:305064

CR Number:   305064 Product Name:   Adaptive Server Enterprise Product Component:   dsedit - UNIX Status:   Closed OS:   Solaris Original Version:   12.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 28 Jan 2003 Duplicate Description Need dsedit/dscp to have a option to enable ssl for interfaces / sql.ini Workaround Description  Manually add ssl entries to interfaces or sql.ini files.

CR:305066

CR Number:   305066 Product Name:   Adaptive Server Enterprise Product Component:   dsedit - UNIX Status:   Closed OS:   Solaris Original Version:   12.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 21 Jul 2010 Fixed Description Need dsedit/dscp to have a option to enable ssl for interfaces / sql.ini Target Version  To Be Determined Review Status  Under review Workaround Description  Manually add ssl entries to interfaces or sql.ini files.

CR:305104

CR Number:   305104 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   voyager Fixed Version Build Resolution Date Closure Code (If Appropriate) 26 Nov 2003 Fixed Description Lowest IO Buffer Pool Information will now be reflected in the A.S.E configuration file. Target Version  To Be Determined

CR:305113

CR Number:   305113 Product Name:   Adaptive Server Enterprise Product Component:   backup server Status:   Closed OS:   macosx Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 May 2003 Duplicate 28 Mar 2003 Fixed Description On Mac OS compress dump and load to a backupserver does not work.

CR:305133

CR Number:   305133 Product Name:   Adaptive Server Enterprise Product Component:   DDLGen Status:   Closed OS:   NA Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.5.1 13 Jan 2003 Bundled Request Description DDLGen doesn't generate the 'with override' attribute of a Database DDL. This caused the ddl to fail when executed against a db, which was created using 'with override' option.

CR:305147

CR Number:   305147 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Mar 2003 Fixed Description The order in which the rows were inserted in a Data Only Locked table via the SELECT INTO <target> FROM <source> ORDER BY command was not predictable. We now retain this sequence by inserting rows in the order of rows received. Workaround Description  N/A

CR:305156

CR Number:   305156 Product Name:   Adaptive Server Enterprise Product Component:   Language Modules Status:   Closed OS:   Linux Original Version:   12.5.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 26 Mar 2003 Fixed 18 Aug 2003 Presently Not Targeted For Any Future Release Of This Product Description On LINUX platform, the Chinese, some Korean entries are missing from the locales.dat file.

CR:305195

CR Number:   305195 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.0.0.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 25 Sep 2003 Fixed 21 Nov 2003 Presently Not Targeted For Any Future Release Of This Product Description The stored procedure sp_sysmon could fail with arithmetic overflow errors if some of the intermediate calculation variables exceed the maxint value. Arithmetic overflow errors however are still possible. To avoid this, the monitoring window needs to be reduced. Workaround Description  Decrease sample time

CR:305232

CR Number:   305232 Product Name:   Adaptive Server Enterprise Product Component:   sybmigrate Status:   Closed OS:   Solaris Original Version:   12.5.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 May 2003 Bundled Request Description The DDL schema migration performance in sybmigrate utility has been improved.

CR:305321

CR Number:   305321 Product Name:   Adaptive Server Enterprise Product Component:   backup server Status:   Closed OS:   Solaris Original Version:   12.5.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 03 Jul 2003 Fixed Description Under certain circumstances, a database dump might hang and will not proceed unless a system database dump is initiated.

CR:305402

CR Number:   305402 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.0.0.6 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16 Feb 2004 Fixed Description An unexpected 1105 error may be reported on a database whose information is being cached, due to the premature access of the cached information. The likelihood of hitting this error increases when the 'number of open databases' is configured too low. Workaround Description  Avoid database descriptor reuse by matching the configuration parameter 'number of open databases' with the total number of databases.

CR:305536

CR Number:   305536 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.0.0.6 Fixed Version Build Resolution Date Closure Code (If Appropriate) 22 Sep 2003 Fixed 12 Jan 2004 Not reproducible with latest version of the product available as of Resolution Date Description Inaccurate histograms may be generated for NUMERIC or DECIMAL columns with negative values. Sometimes error 1763, "Cannot insert rows into sysstatistics, due to multiple equal frequency values, please contact Sybase Technical Support." may be raised. Workaround Description  Add another value or change numeric to numeric (#,1)

CR:305642

CR Number:   305642 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 31 Mar 2003 Fixed Description Data truncation may occur on character or binary data that is passsed to Adaptive Server as a host variable to a Dynamic SQL statement. Truncation occurs when BOTH the following hold true: 1) The dynamic parameter marker is used as the argument to a builtin function or a string concatenation expression. For example (using Embedded/SQL syntax, but not limited to Embedded/SQL): PREPARE s FROM "SELECT 1 FROM t WHERE col1 = col2 + '?'" where the host variable data is greater than 255 bytes. 2) The dynamic statement is executed more than once, and the second execution uses data that exceeds in length the data used on the first execution. For example: EXECUTE s USING :one_thousand_byte_var; . . . EXECUTE s USING :two_thousand_byte_var;

CR:305687

CR Number:   305687 Product Name:   Adaptive Server Enterprise Product Component:   omni Status:   Closed OS:   Microsoft Windows NT Original Version:   12.5.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 03 Mar 2003 Duplicate Description Proxy table on ASE 12.5 doesn't contain all columns from the original table if one of the remote columns has a default set to it. Only seems to happen in conjunction with DC, Workaround Description  In DCA, set CSPColumnsODBCVersion to 2

CR:305738

CR Number:   305738 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Unknown Original Version:   voyager Fixed Version Build Resolution Date Closure Code (If Appropriate) 04 Feb 2004 Fixed 26 Feb 2004 One-off Provided Description ASE can run out of Unilib cache memory in an SMP environment, with many simultaneous connections, each of which is configured for a multi-byte character set (e.g. SJIS/EUCJIS)

CR:305825

CR Number:   305825 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   all Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 Feb 2003 Fixed Description Stored Procedures folder in Sybase Central ASE Plug-in shows SQLJ Procedures also along with Stored Procedures.

CR:305827

CR Number:   305827 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 27 Mar 2003 Fixed 10 Sep 2003 Fixed Description A 7791 error, "Unable to remap lockid for table <table_name> in database <db_name>" or error 267, "Object '<table_name>' cannot be found." may be reported when executing a stored procedure that does a CREATE TABLE under a IF statement and a SELECT from the same table.

CR:305865

CR Number:   305865 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 28 Mar 2003 Fixed 09 Apr 2003 Fixed Description A new functionality has been added to perform some simple sanity checks on 'sysgams' system table when command DBCC CHECKTABLE('sysgams') is executed. Workaround Description  If this new DBCC CHECKTABLE('sysgams') raises the new 15002 error indicating that SYGAMS has less extents reserved than expected then DBCC GAM() with option FIX should correct this problem.

CR:305952

CR Number:   305952 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   all Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 07 Mar 2003 Fixed Description There is no 'Generate DDL' option in the context menu for SQLJFunctions and SQLJProcedures.

CR:305953

CR Number:   305953 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   all Original Version:   voyager Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Jul 2003 Fixed Description Provide an option to filter certain objects from the output of the database/table ddl.

CR:306105

CR Number:   306105 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 25 Mar 2003 Fixed Description One session logged in with -Jsjis to a EUCJIS server with 'enable unicode conversion' initally set to 2, and changed 'unicode' to 2. When another session logs in with -Jsjis and inserts Zenkaku chars, 102 and 105 errors are raised. Workaround Description  Re-boot ASE OR Change "enable unicode conversions" from EUCJIS session

CR:306114

CR Number:   306114 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   NA Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 31 Jan 2003 Fixed 25 Feb 2003 Fixed Description During the creation of a database with a size greater than 63 G-bytes, the message "Sysgams in database <value> has <value> extents, but the database needs <value>. Please contact Technical Support for assistance." may be incorrectly reported in the error log. Workaround Description  The warning can be ignored if it is raised at create database or at online database. It will get fixed with no action needed.

CR:306117

CR Number:   306117 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   NA Original Version:   12.0.0.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 29 Jan 2003 Fixed 06 Mar 2003 Fixed Description A 233 error will be incorrectly reported when compiling a procedure that has an INSERT that does not supply data for a column having a default when the default is added using ALTER TABLE immediately after the SELECT INTO that created the object.

CR:306145

CR Number:   306145 Product Name:   Adaptive Server Enterprise Product Component:   omni Status:   Closed OS:   Solaris Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 04 Mar 2003 Fixed 31 Mar 2003 Fixed Description Error 1158 may be reported together with a stack trace in the error log including the modules 'attrib_insrow' and 'pg__allocate' when a SELECT-INTO command is executed that has a local table as destination and a proxy table as source corresponding to the execution of an external remote procedure. Workaround Description  use trace flag 5304 to disable LSA within SELECT INTO.

CR:306154

CR Number:   306154 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 22 Jan 2003 Fixed 23 Jan 2003 Fixed 27 Jan 2003 Fixed 05 Mar 2003 Fixed Description When a duplicate row or key is inserted into a table where an index has been created with ignore_dup_key or ignore_dup_row, @@error value is set to 3601 to indicate the command has been aborted. This value should be zero as the duplicate key or row has been specified, to be ignored, through the create index options.

CR:306207

CR Number:   306207 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX Original Version:   12.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 Mar 2003 Fixed 26 Mar 2003 Fixed 19 Dec 2003 One-off Provided Description On the AIX platform, a server configured for multiple engines may die at boot time after all databases have been recovered. Messages similar to "os_process_exists: kill failed. pid 1 Not owner" and "engine 6, os pid 1 exited" will appear in the log. Workaround Description  See CR 273460 for details on a workaround to the engine online issue.